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 ```