Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group