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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: 甄明洋 <zhenmingyang(at)yeah(dot)net>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "Aleksander Alekseev" <a(dot)alekseev(at)postgrespro(dot)ru>, pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Re:Re: Re: [BUGS] Return value error of‘to_timestamp’
Date: 2016-08-17 13:49:38
Message-ID: 7406.1471441778@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

=?UTF-8?B?55SE5piO5rSL?= <zhenmingyang(at)yeah(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andres Freund 2016-08-17 15:41:17 Re: BUG #14243: pg_basebackup failes by a STATUS_DELETE_PENDING file
Previous Message Michael Paquier 2016-08-17 11:09:33 Re: jsonb_array_elements issue