Horton

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

myzhen <zhenmingyang@yeah.net>

View thread
From: 甄明洋 <zhenmingyang@yeah.net>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>, "Aleksander Alekseev" <a.alekseev@postgrespro.ru>, pgsql-bugs <pgsql-bugs@postgresql.org>
Date: 2016-08-18T09:57:48Z
Lists: pgsql-bugs 
Aha i got it. thanks.
Why don't use a unified time zone Convention ?


If user is not particularly familiar with the document, 
Maybe will feel confused.





At 2016-08-17 21:49:38, "Tom Lane" <tgl@sss.pgh.pa.us> wrote:
>=?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