Re: world meaningful date time input

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?