From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: robert.kruus@gov.sk.ca
Subject: Datetime formatting
Date: Thu, 27 Jan 2022 15:43:00 +0000
Message-ID: <164329818006.714.3944569873739768861@wrigleys.postgresql.org> (raw)
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/14/datatype-datetime.html
Description:
The latest ISO 8601-1:2019 standard requires the "T" character as the
separator in text representations of datetimes. RFC 3339 is more flexible
and allows the space between the date and time. So technically,
SELECT CAST('2021-02-13 06:00:00-06'::timestamptz AS TEXT); ------>
2021-02-13 06:00:00-06
is no longer considered valid under the latest edition, it would have to be
2021-02-13T06:00:00-06
I don't have access to the actual standard, but
https://ijmacd.github.io/rfc3339-iso8601/ seems to summarize it quite well,
and from what I could find publicly available.
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.
Or update the actual database behavior to match the new standard so no
documentation changes are required.
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: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, robert.kruus@gov.sk.ca
Subject: Re: Datetime formatting
In-Reply-To: <164329818006.714.3944569873739768861@wrigleys.postgresql.org>
* 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