Hello All,
I am a newbie in PHP and wanna know how to track the time (GMT standards) when lattitude and longitude locations are given.
It would be helpful if anyone could provide me with the code for the same!
Help Needed Urgently.
Regards
To track time (GMT standards) given lattitude & longitud
Moderator: General Moderators
-
dream2rule
- Forum Contributor
- Posts: 109
- Joined: Wed Jun 13, 2007 5:07 am
To track time (GMT standards) given lattitude & longitud
Last edited by dream2rule on Thu Jun 14, 2007 12:35 am, edited 1 time in total.
I think it's even worse than that. Some time zones are irregular shapes and the only way I know to really determine the time zone from Lat/Long is to use GIS. Fortunately there is some GIS support in MySQL, but it will be a really messy operation. Take a look at http://dev.mysql.com/tech-resources/art ... mysql.htmlfeyd wrote:You will need the time zone lines in latitude and longitude as well. After that, it's a bunch of comparisons.
- feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
Right. I was actually referring to the irregular shapes in "it's a bunch of comparisons" .. although vaguely.califdon wrote:I think it's even worse than that. Some time zones are irregular shapes and the only way I know to really determine the time zone from Lat/Long is to use GIS. Fortunately there is some GIS support in MySQL, but it will be a really messy operation. Take a look at http://dev.mysql.com/tech-resources/art ... mysql.html
- superdezign
- DevNet Master
- Posts: 4135
- Joined: Sat Jan 20, 2007 11:06 pm
- Gente
- Forum Contributor
- Posts: 252
- Joined: Wed Jun 13, 2007 9:43 am
- Location: Ukraine, Kharkov
- Contact:
GMT and GeoIP
There are some databases with GMT of some cities (about 500 and 1000).
Also you can find GeoIP tables with city, longitude. So you can find the closest city by latitude that presented in GMT table.
This way you cat find out GMT with a high probability.
Also you can find GeoIP tables with city, longitude. So you can find the closest city by latitude that presented in GMT table.
This way you cat find out GMT with a high probability.
-
dream2rule
- Forum Contributor
- Posts: 109
- Joined: Wed Jun 13, 2007 5:07 am