Re: Re:Re: Re: [BUGS] Return value error of‘to_timestamp’ - Mailing list 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