"Konstantin Kulikov" <k.e.kuli...@gmail.com> writes: > Description: incorrect returned value of time
> select current_timestamp at time zone 'GMT+3'; > will return actually 'GMT-3' This is unfortunate, but it's not a bug. There are two different standards about the sign of timezone offsets, and Postgres has to deal with both of them. See http://www.postgresql.org/docs/current/static/datatype-datetime.html#DATATYPE-TIMEZONES particularly the note that Another issue to keep in mind is that in POSIX time zone names, positive offsets are used for locations west of Greenwich. Everywhere else, PostgreSQL follows the ISO-8601 convention that positive timezone offsets are east of Greenwich. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
