正华吕 <kainwen@gmail.com> writes: > I test the following SQL in pg15dev (seems same behavior as the > previous version). > select '2020701'::date; > date > ------------ > 0202-07-01 > (1 row) > At the first glance, the result seems quite strange.
[ shrug... ] You left out a zero. It's not apparent to me that this answer is wrong.
If you want to pursue this question, you could start by bisecting to find just which commit changed it and why.
The goal seemed to be able to accept 5-digit years…this behavior change didn’t show in the tests (or discussion) though I didn’t look for the of testing the pre-existing failure mode.