Good Idea Adrian!
What I want is to be able to insert into my project's database, times given by anybody anywhere on the planet (the SUBMITTER), add the appropriate timezone in the insert statement so that it in 'GMT/UMT' neutral'. I believe this is the way Postgres does it, storing times in GMT time.
When I pull it out for anyone on the planet (for the QUERRIER), by their geographic location or address, I give the SELECT statement the timezone value of the QUERRIER and adjust it to the location of the QUERRIER also supplying them the time in the geographical location of the SUBMITTER.
> From: Adrian Klaver <aklaver@xxxxxxxxxxx>
<snip>
> Subject: Re: timestamp with time zone tutorial
Dennis Gearon wrote:
> > None of the examples of converting a string
> to_timestamp() show using a
> > time zone input as an input.Does it allow full length
> timezones for
> > daylight savings time at the timestamp instant in
> time, or just an
> > abbreviation for a fixed offset?
> >
> >
>
> This might be easier if you could give an example of what
> you are trying to
> accomplish :)
>
>
> --
> Adrian Klaver
> aklaver@xxxxxxxxxxx
>
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
