RE: Datetime formatting

Sigh, I should just go home now...

From: David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
Sent: Thursday, January 27, 2022 10:26 AM
To: Kruus, Robert SPSA <Robert(dot)Kruus(at)gov(dot)sk(dot)ca>; Pg Docs <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: Re: Datetime formatting

WARNING: This message originated from a source that is not managed by SaskBuilds and Procurement, Information Technology Division. Do not visit links or open attachments unless you trust the sender's email ID and ensure it is not a spam/phishing email.

On Thu, Jan 27, 2022 at 9:13 AM PG Doc comments form <noreply(at)postgresql(dot)org<mailto:noreply(at)postgresql(dot)org>> wrote:

Page: https://www.postgresql.org/docs/14/datatype-datetime.html<https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.postgresql.org%2Fdocs%2F14%2Fdatatype-datetime.html&data=04%7C01%7Crobert.kruus%40gov.sk.ca%7C3d5b1a71782543fbf5a108d9e1b1cc7f%7Ccf4e8a24641b40d2905e9a328b644fab%7C0%7C0%7C637788976016986406%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=xWUWibnXKlVvOEkHVll2BBj6mrddvilyvVU9BQ7gIbI%3D&reserved=0>

Might want to make a note that the current behavior does not match the
latest standard, but does match previous editions and/or RFC 3339.

We have such a note - it even gets printed in a big blue box.

"""
ISO 8601 specifies the use of uppercase letter T to separate the date and time. PostgreSQL accepts that format on input, but on output it uses a space rather than T, as shown above. This is for readability and for consistency with RFC 3339 as well as some other database systems.
"""

David J.