Re: TIMEZONE not working?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "cnliou" <cnliou(at)so-net(dot)net(dot)tw>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: TIMEZONE not working?
Date: 2003-11-26 07:53:14
Message-ID: 12095.1069833194@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"cnliou" <cnliou(at)so-net(dot)net(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marek Lewczuk 2003-11-26 08:21:25 Re: PostgreSQL is much faster than MySQL, only when...
Previous Message Eamon Reyn 2003-11-26 06:41:37 Java Strings and quote marks