Cefull Lo <cefull@xxxxxxxxx> writes: > I'm located in Hong Kong, UTC+8 time zone. When I > select current_timestamp; > 2012-01-13 23:56:16.825558+08 > However, when I > select current_timestamp at time zone 'UTC+8'; > I expect the result is the same as the above one. Sorry, but it isn't. A time zone name spelled that way is a POSIX time zone specification, and in POSIX positive offsets are west of Greenwich, not east. See http://www.postgresql.org/docs/9.1/static/datatype-datetime.html#DATATYPE-TIMEZONES 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
