Re: Setting timezone: is it bug or intended?

Hello Yora Sokolov,

On 18.03.2011 09:22, Yura Sokolov wrote:
>
> postgres=# set timezone='+03:00';
> SET
> postgres=# select now();
>              now
> ------------------------------
>  2011-03-18 05:20:35.46008-03
> (1 row)

Maybe this is not a bug - just an inconsistence:

Look here (tested with 9.0):

=# set timezone='+3.5';
SET
=# select current_timestamp;
                now
----------------------------------
  2011-03-21 16:05:34.761112+03:30
(1 row)

In any case, this should get documented.

Susanne


--
Susanne Ebrecht - 2ndQuadrant
PostgreSQL Development, 24x7 Support, Training and Services
www.2ndQuadrant.com