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 <[email protected]>
<snip>
> Subject: Re: [GENERAL] 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
> [email protected]
>
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
