Horton

Re: Re:Re: Re: [BUGS] Return value error of‘to_timestamp’

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: 甄明洋 <zhenmingyang@yeah.net>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>, "Aleksander Alekseev" <a.alekseev@postgrespro.ru>, pgsql-bugs <pgsql-bugs@postgresql.org>
Date: 2016-08-17T13:49:38Z
Lists: pgsql-bugs 
=?UTF-8?B?55SE5piO5rSL?= <zhenmingyang@yeah.net> writes:
>    this looks like, the sign  plus and minus are inverted, i dont understand why?

Time zone names follow the POSIX convention (plus is west of Greenwich).
Timestamp I/O follows the ISO convention (plus is east of Greenwich).
Aren't standards fun?

See para starting "One should be wary ..." here:
https://www.postgresql.org/docs/9.5/static/datatype-datetime.html#DATATYPE-TIMEZONES

			regards, tom lane