BUG #16309: Postgres's ISO 8601 date output is not compliant - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #16309: Postgres's ISO 8601 date output is not compliant
Date
Msg-id 16309-624405df40e39b05@postgresql.org
Whole thread Raw
Responses Re: BUG #16309: Postgres's ISO 8601 date output is not compliant
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      16309
Logged by:          Charlie Hayes
Email address:      cosmotic@gmail.com
PostgreSQL version: 11.6
Operating system:   docker
Description:

Per Postgres's own documentation, ISO 8601 date output is NOT compliant
(Despite what the style name suggests):
https://www.postgresql.org/docs/12/datatype-datetime.html#DATATYPE-DATETIME-OUTPUT

The existing "Style Specification" name should be changed to something other
than ISO since it is NOT ISO compliant.

If the output from postgres cannot be parsed by a strictly ISO 8601 parser,
than it should not be considered an ISO 8601 string.

A new style should be create that is actually ISO compliant.


pgsql-bugs by date:

Previous
From: Robert Haas
Date:
Subject: Re: BUG #16302: too many range table entries - when count partitiontable(65538 childs)
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #16309: Postgres's ISO 8601 date output is not compliant