Mysteries of the future - Mailing list pgsql-docs

From PG Doc comments form
Subject Mysteries of the future
Date
Msg-id 171276122213.681.531905738590773705@wrigleys.postgresql.org
Whole thread Raw
Responses Re: Mysteries of the future
List 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 by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: tools.ietf.org is decommissioned and our links are redirected
Next
From: Tom Lane
Date:
Subject: Re: Mysteries of the future