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