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  ("Kruus, Robert SPSA" <Robert.Kruus@gov.sk.ca>)
Список 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 по дате отправления:

Предыдущее
От: PG Doc comments form
Дата:
Сообщение: Datetime formatting
Следующее
От: "Kruus, Robert SPSA"
Дата:
Сообщение: RE: Datetime formatting