21.03.2011 15:51, Susanne Ebrecht пишет:
Hello Yora Sokolov,

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


My question were about sign of timezone:

postgres=# set timezone='+03'; -- positive
postgres=# select now();
2011-03-18 11:20:29.696671+03 -- positive
postgres=# set timezone='+03:00'; -- positive
2011-03-18 05:20:35.46008-03 -- negative

Is it intended?

Yura Sokolov

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to