PG Doc comments form <nore...@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