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
|
Список | 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 по дате отправления: