From: Kruus, Robert SPSA <Robert.Kruus@gov.sk.ca>
To: Pg Docs <pgsql-docs@lists.postgresql.org>
Subject: RE: Datetime formatting
Date: Thu, 27 Jan 2022 16:41:35 +0000
Message-ID: <YT2PR01MB50392D28125466B96F7AA4A6C6219@YT2PR01MB5039.CANPRD01.PROD.OUTLOOK.COM> (raw)
In-Reply-To: <CAKFQuwZcKcPRgWLQ0aG+nSEosj2SrSQvpCwQ9MQxcuRemdjBBQ@mail.gmail.com>
References: <164329818006.714.3944569873739768861@wrigleys.postgresql.org>
<CAKFQuwZcKcPRgWLQ0aG+nSEosj2SrSQvpCwQ9MQxcuRemdjBBQ@mail.gmail.com>
Sigh, I should just go home now...
From: David G. Johnston <david.g.johnston@gmail.com>
Sent: Thursday, January 27, 2022 10:26 AM
To: Kruus, Robert SPSA <Robert.Kruus@gov.sk.ca>; Pg Docs <pgsql-docs@lists.postgresql.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@postgresql.org<mailto:noreply@postgresql.org>> wrote:
Page: https://www.postgresql.org/docs/14/datatype-datetime.html<https://can01.safelinks.protection.outl...;
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: Robert.Kruus@gov.sk.ca, pgsql-docs@lists.postgresql.org
Subject: RE: Datetime formatting
In-Reply-To: <YT2PR01MB50392D28125466B96F7AA4A6C6219@YT2PR01MB5039.CANPRD01.PROD.OUTLOOK.COM>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox