Re: world meaningful date time input

On Wed, Jun 16, 2010 at 8:25 PM, 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?