Re: Datetime formatting
| От | David G. Johnston |
|---|---|
| Тема | Re: Datetime formatting |
| Дата | |
| Msg-id | CAKFQuwZcKcPRgWLQ0aG+nSEosj2SrSQvpCwQ9MQxcuRemdjBBQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Datetime formatting (PG Doc comments form <noreply@postgresql.org>) |
| Ответы |
RE: Datetime formatting
|
| Список | 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 по дате отправления: