From: | Dennis Gearon <gearond(at)sbcglobal(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: world meaningful date time input |
Date: | 2010-06-17 06:02:46 |
Message-ID: | 239450.51216.qm@web82107.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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/timezone has 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(at)sbcglobal(dot)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?
>
From | Date | Subject | |
---|---|---|---|
Next Message | stefano bonnin | 2010-06-17 06:17:33 | Given N, finding the interval of N hours with max(sum(..)) |
Previous Message | Anton Maksimenkov | 2010-06-17 05:21:11 | Re: consequent PQsendQueryPrepared() failed: another command is already in progress |