On Wed, Jun 16, 2010 at 8:25 PM, Dennis Gearon <gearond@sbcglobal.net> wrote:
>
> I've got an application brewing that gathers the following data:
> location (lat/lon)
> time (no time zone)
> date. (no time zone)
>
> The eventual goal is to be able to search chronologically using timestamps for the data anywhere in the world, from
anylocation, using local time as a reference for any future date and time.
>
> From the (lat/lon) it's possible to get:
> named time zone
> standard time zone offset (non dst)
> by some special web services, get dates and amounts of
> day light savings time
>
> From there, it could possible to combine all the datums and create a timestamp with timezone (i.e. it's stored in
absolutetime (in seconds) relative to GMT)
>
> Any easier way to do this?
Why not set the tz to the one the date / time came from, insert into
timestamptz, then use timestamptz at timezone to retrieve it?