On Wed, Jun 16, 2010 at 8:25 PM, Dennis Gearon <[email protected]> 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? -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
