From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | robert(dot)kruus(at)gov(dot)sk(dot)ca, Pg Docs <pgsql-docs(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Datetime formatting |
Date: | 2022-01-27 16:26:21 |
Message-ID: | CAKFQuwZcKcPRgWLQ0aG+nSEosj2SrSQvpCwQ9MQxcuRemdjBBQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
On Thu, Jan 27, 2022 at 9:13 AM PG Doc comments form <noreply(at)postgresql(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Kruus, Robert SPSA | 2022-01-27 16:41:35 | RE: Datetime formatting |
Previous Message | PG Doc comments form | 2022-01-27 15:43:00 | Datetime formatting |