Horton

Re: Mysteries of the future

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: y.saburov@gmail.com
Cc: pgsql-docs@lists.postgresql.org
Date: 2024-04-11T14:20:38Z
Lists: pgsql-docs 
PG Doc comments form <noreply@postgresql.org> writes:
> SELECT to_date('20000-1131', 'YYYY-MMDD');
> ERROR:  22008: date/time field value out of range: "20000-1131"

What exactly do you find wrong with that?  November doesn't have
31 days.

Sure, we could have a discussion about the probability of the
Gregorian calendar still being in use 18000 years from now,
but it doesn't seem very profitable.  What else do you want
to use?

			regards, tom lane

Commits

  1. Doc: fix bogus to_date() examples.