Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgresql datetimes are not ISO-8601 compliant, but RFC3339 - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: Postgresql datetimes are not ISO-8601 compliant, but RFC3339
Date
Msg-id CAKFQuwZ_o43dieaz56XPw6woLPqxmzv=b7zhwf1Y4OnRZiLYiA@mail.gmail.com
Whole thread Raw
In response to Postgresql datetimes are not ISO-8601 compliant, but RFC3339  (Leon Timmermans <fawaka@gmail.com>)
List pgsql-bugs
Tree view
On Friday, February 11, 2022, Leon Timmermans <fawaka@gmail.com> wrote:
Postgresql calls its datetime format ISO-8601 in the documentation and in the DateStyle setting, but it is in fact not ISO compliant, but RFC3339 instead.


This is indeed what we document.  It is not going to change.  It is not a bug, just a choice that you disagree with.

David J.

pgsql-bugs by date:

Previous
From: Leon Timmermans
Date:
Subject: Postgresql datetimes are not ISO-8601 compliant, but RFC3339
Next
From: "David G. Johnston"
Date:
Subject: Re: A bug with the TimeStampTZ data type and the 'AT TIME ZONE' clause