Re: Datetime formatting - Mailing list pgsql-docs

From David G. Johnston
Subject Re: Datetime formatting
Date
Msg-id CAKFQuwZcKcPRgWLQ0aG+nSEosj2SrSQvpCwQ9MQxcuRemdjBBQ@mail.gmail.com
Whole thread Raw
In response to Datetime formatting  (PG Doc comments form <noreply@postgresql.org>)
Responses RE: Datetime formatting
List pgsql-docs
On Thu, Jan 27, 2022 at 9:13 AM PG Doc comments form <noreply@postgresql.org> wrote:

Page: https://www.postgresql.org/docs/14/datatype-datetime.html

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.

pgsql-docs by date:

Previous
From: PG Doc comments form
Date:
Subject: Datetime formatting
Next
From: "Kruus, Robert SPSA"
Date:
Subject: RE: Datetime formatting