Postgres Pro
Downloads
Home   >   mailing lists

Re: TIMEZONE not working? - Mailing list pgsql-general

From Tom Lane
Subject Re: TIMEZONE not working?
Date
Msg-id 12095.1069833194@sss.pgh.pa.us
Whole thread Raw
In response to TIMEZONE not working?  ("cnliou" <cnliou@so-net.net.tw>)
List pgsql-general
Tree view 
"cnliou" <cnliou@so-net.net.tw> writes:
> If I correctly understand v7.4 manual, value, say,
> '2003-11-26 12:00' in TIMESTAMP WITHOUT TIMEZONE column
> should output '2003-11-26 19:00' for "+08:00" timezone.

Not at all.  TIMESTAMP WITHOUT TIMEZONE will not react to timezone
environment at all.  What part of the docs gave you another impression?

            regards, tom lane

pgsql-general by date:

Previous
From: "cnliou"
Date:
Subject: TIMEZONE not working?
Next
From: Marek Lewczuk
Date:
Subject: Re: PostgreSQL is much faster than MySQL, only when...