Thanks Scott
That's basically what I'm planning on doing, and hopefully described. The server will only in 1-10 locations around the
world,and I can't use the timezone of the servers anyway, nor the user's input device/browser/phone. The
offset/timezonehas to be the one for the geographical location of the datum.
But the process you described went one further than I knew, the output in the local tz. Thanks for that.
> 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 any location, 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 absolute time (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?
>