Timezone lookup?

[Ted Byers]

Is there, in the various timezone packages, support somewhere for
finding out what the timezone is for a given city/state?  I have, in
my database, extensive data with the usual contact information from
users from around the world.  If at all possible, I would like to
query the data managed by one of the timezone packages to determine
the local users' timezones from their mailing address.  Is this
possible?  Using what?

This data also has date and time stamps in UTC, and converting these
to whatever timezone is desired is easy to do using any of several
datetime packages I have tried.  But the problem remains to figure out
what time zone to use when ALL you have for a given person is his
mailing address.  Can that problem be solved?

Thanks

Ted

Re: Timezone lookup?

[Yitzchak Scott-Thoennes]

On Wed, August 5, 2009 12:52 pm, Ted Byers wrote:
 Is there, in the various timezone packages, support somewhere for
 finding out what the timezone is for a given city/state?  I have, in my
 database, extensive data with the usual contact information from users
 from around the world.  If at all possible, I would like to query the data
 managed by one of the timezone packages to determine the local users'
 timezones from their mailing address.  Is this possible?  Using what?

For countries with a single timezone, you can look it up by iso3166 two
character code in %DateTime::TimeZone::Catalog::ZONES_BY_COUNTRY.

For other countries, I don't know of such support.  You can read the
comments in zone.tab or the longer comments in the region files in
the tzdata package at ftp://elsie.nci.nih.gov/pub/.