Question on cast string to date

Hi, 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. Go through the code, postgres use date_in to do the cast, and firs

Re: Question on cast string to date

Thanks all. David G. Johnston 于2022年5月10日周二 13:41写道： > On Monday, May 9, 2022, Tom Lane wrote: > >> =?UTF-8?B?5q2j5Y2O5ZCV?= writes: >> > I test the following SQL in pg15dev (seems same behavior as the >> > previous version). >> > select '2020701'::date; >> > date >> >-