ISO8601 vs POSIX offset clarification

From: Bharanee Rathna <deepfryed(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: ISO8601 vs POSIX offset clarification
Date: 2017-12-04 02:39:43
Message-ID: CAOX4-H7gnUNV50d7N9E0V6q=LVuu4ewiuzmnBXmggkBs8DgeSA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

the documentation around how numeric offsets are parsed from strings is a
bit confusing, are they supposed to be treated as ISO8601 or POSIX ?

e.g.

select '2017-12-01 11:00:00 +11:00'::timestamp with time zone at time zone
'+11:00';
timezone

---------------------

2017-11-30 13:00:00

select '2017-12-01 11:00:00 -11:00'::timestamp with time zone at time zone
'+11:00';

timezone

---------------------

2017-12-01 11:00:00

The Table 8-12. Time Zone Input section at
https://www.postgresql.org/docs/9.3/static/datatype-datetime.html seems to
imply that numeric offsets would be treated as ISO8601. It's all a big
confusing and would appreciate some clarification or pointer to
documentation.

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2017-12-04 02:55:53 Re: ISO8601 vs POSIX offset clarification
Previous Message Michael Paquier 2017-12-04 01:42:43 Re: JSON out of memory error on PostgreSQL 9.6.x