On Thu, Oct 22, 2009 at 2:41 PM, the6campbells wrote:
> Question.. is there a way that I can get Postgres to return the tz as
> supplied on the insert statement
PostgreSQL converts the timezone to GMT and stores it with no offset,
then adds an offset based on the TZ of the client requesting it ba
the6campbells writes:
> Question.. is there a way that I can get Postgres to return the tz as
> supplied on the insert statement
No.
regards, tom lane
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgres
Question.. is there a way that I can get Postgres to return the tz as
supplied on the insert statement
insert into TTSTZ(RNUM, CTSTZ) values ( 0, null);
insert into TTSTZ(RNUM, CTSTZ) values ( 1, timestamp with time zone
'2000-12-31 12:00:00.0-05:00');
insert into TTSTZ(RNUM, CTSTZ) values ( 2, ti