Timezone lookup

Question

I have a file that contains the following in a csv file;
country,region,city,postalCode,metroCode,areaCode

I need to find the time zone for the entries.

I have seen olson database and geonames, i was lost with olson database. couldnt find anything useful.

is there any web site i can access the time zone information based on country, region, city?

Thanks.

score 2 · Accepted Answer · answered Mar 02 '10 at 23:57

2

I was able to query this.

http://www.earthtools.org/webservices.htm

answered Mar 02 '10 at 23:57

DarthVader

52,984
76
209
300

score 1 · Answer 2 · edited Nov 17 '11 at 14:13

1

Did you have a look at this here...the timezone database is in the public domain.

edited Nov 17 '11 at 14:13

answered Mar 01 '10 at 16:02

t0mm13b

34,087
8
78
110

that s olson database, if you look at it, it s a total mess, i couldnt find anything useful. – DarthVader Mar 01 '10 at 16:02
@user177883: Sounds like you're looking to determine what timezone a user is in based on their address, whereas the Olson database tells you the rules which determine the local time in that timezone. It does list by city, but that's really just a convenient set of labels. – e100 Mar 08 '10 at 17:35

score 0 · Answer 3 · answered Dec 10 '10 at 05:31

0

If you can geocode your address to a latitude/longitude pair, you can give those coordinates plus a datetime to DRT Engine and get back a timezone offset.

answered Dec 10 '10 at 05:31

Jules

19
2

Timezone lookup

3 Answers3

Linked