A Gilmore <agilmore(at)shaw(dot)ca> writes:
> I have table holding timestamps without a time zone (considered GMT).
> Ill being making inserts into this table with a timestamp like 3pm PST,
> which I need to be translated and inserted as GMT. Later this will
> likely be queried where I need the timestamp returned for say EST.
This would all work a lot better if the column were timestamp *with*
timezone. Trying to do it the way you are is just swimming upstream
to no particular purpose.
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: Kumar S||Date: 2004-09-20 02:15:21|
|Subject: Creating a new column with SERIAL as data type|
|Previous:||From: A Gilmore||Date: 2004-09-19 01:11:11|
|Subject: Re: DST and time zones|