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.
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.
I was able to query this.
http://www.earthtools.org/webservices.htm
Did you have a look at this here...the timezone database is in the public domain.