Re: BUG #5552: incorrect returned value of time - Mailing list pgsql-bugs

"Konstantin Kulikov" <k.e.kulikov@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