converting google latitude to a timezone

Here's one to take a look at.

 

Would the following be more what you're after?

http://www.geonames.org/
http://www.twinsun.com/tz/tz-link.htm

 

Let me unconfuse you.

Visit this site to demo and possibly purchase their DB15 product which is a powerful and easy to use database that returns a lot of information about a user using geo-location techniques.

http://www.ip2location.com/

For example, I simply visited the site and it reported all this about me:

As you can see, the database fields include longitude and latitude and time zone offset. You can either query based on IP as it did for me, or contact their helpdesk or read their documentation and see if you can run your own query passing the latitude/longtitude if you have that information already to get the time zone offset. Once you have that, you calculate local time by adding or subtracting the time zone offset from current GMT time.

Example: GMT -4:00 means the current GMT time minus 4 hours, i.e. if GMT is 8pm, my local time is 4pm. It's up to you to query the database properly and calculate the time using whatever server side language you use. In PHP you'd work with gmdate and gmmktime functions.

-jim