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.