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
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 |