Mysteries of the future

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема Mysteries of the future
Дата
Msg-id 171276122213.681.531905738590773705@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: Mysteries of the future  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/16/functions-formatting.html
Description:

I'm not sure that there will be 31 days in 11 months; although postgresql
probably knows better what will happen in 20000 

For example (with the year 20000): to_date('200001131', 'YYYYMMDD') will be
interpreted as a 4-digit year; instead use a non-digit separator after the
year, like to_date('20000-1131', 'YYYY-MMDD') or to_date('20000Nov31',
'YYYYMonDD').

https://www.postgresql.org/docs/current/functions-formatting.html

```sql
SELECT to_date('20000-1131', 'YYYY-MMDD');

ERROR:  22008: date/time field value out of range: "20000-1131"
LOCATION:  DateTimeParseError, datetime.c:4021
```

В списке pgsql-docs по дате отправления:

Предыдущее
От: Daniel Gustafsson
Дата:
Сообщение: Re: tools.ietf.org is decommissioned and our links are redirected
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Mysteries of the future