Setting timezone: is it bug or intended?

From: Yura Sokolov <funny(dot)falcon(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Setting timezone: is it bug or intended?
Date: 2011-03-18 08:22:11
Message-ID: 4D831633.4020504@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

postgres=# set timezone='+03';
SET
postgres=# select now();
now
-------------------------------
2011-03-18 11:20:29.696671+03
(1 row)

postgres=# set timezone='+03:00';
SET
postgres=# select now();
now
------------------------------
2011-03-18 05:20:35.46008-03
(1 row)

(checked with 8.4 and 9.0)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jonathan Brinkman 2011-03-18 14:55:03 TO_CHAR(timestamptz,datetimeformat) wrong after DST change
Previous Message Korry Douglas 2011-03-17 20:52:58 Re: BUG #5935: Log lotation not working for default log format