silly8888 <silly8888@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general