Re: Time zone 'GMT+8'

silly8888 <silly8888@gmail.com> writes:
>> From http://www.postgresql.org/docs/current/static/datatype-datetime.html#DATATYPE-TIMEZONES

> Another issue to keep in mind is that in POSIX time zone names,
> positive offsets are used for locations west of Greenwich.

Yeah, we're caught between two incompatible conventions :-(.  I suggest
reading the whole section linked to above, it should make things
clearer.

            regards, tom lane