Hi,
Assuming your coordinates match, I suppose you could load a layer
containing time zone data into postgis from somthing like
http://openmap.bbn.com/data/shape/timezone/ (Haven't looked at possible
licences of that data though)
You could then use one of the postgis spatial operators to find
overlapping or nearby countries and retrieve their timezone offset and
retreievethe time using the date and time functions of PostgreSQL.
Anyways, just a thought.
Cheers,
Per-Olof
Nelson Correia skrev:
Hi,
I want to know the date and time at a specific location, represented by a
pair of coordinates.
Is there any way to convert a pair of coordinates to a timezone? Or directly
obtain the local time at the coordinates that I specify?
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
