PG Doc comments form <noreply(at)postgresql(dot)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