Setting timezone: is it bug or intended? - Mailing list pgsql-bugs

From Yura Sokolov
Subject Setting timezone: is it bug or intended?
Date
Msg-id 4D831633.4020504@gmail.com
Whole thread Raw
Responses Re: Setting timezone: is it bug or intended?  (Susanne Ebrecht <susanne@2ndQuadrant.com>)
List 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)

pgsql-bugs by date:

Previous
From: Korry Douglas
Date:
Subject: Re: BUG #5935: Log lotation not working for default log format
Next
From: "Jonathan Brinkman"
Date:
Subject: TO_CHAR(timestamptz,datetimeformat) wrong after DST change