út 10. 5. 2022 v 6:28 odesílatel 正华吕 <kain...@gmail.com> napsal:
> 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 firstly > use last 2 chars to > get the day, and the 2 chars to get the month, and all remaining chars > as year. > > The question here is: should we throw error for such input? Or what > standard postgres is > using to cast such kind of string? > This is ISO format https://en.wikipedia.org/wiki/ISO_8601 https://postgresqlco.nf/doc/en/param/DateStyle/ Regards Pavel > > Thanks. >
