Thread: Bug #607: to_date() function bug
Nurlan Mukhanov (nurlan@otdyh.kz) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description to_date() function bug Long Description otdyh=# select to_date(20020200,'YYYYMMDD'); to_date ------------ 2002-02-01 must be 2002-01-31 !! Why??? 00 hours 00 minutes 00 seconds - next day or last day??? last day!!! 2000 year is 20 century or 21 century? - 20!! same here! 00 day - is the last day of the previous month! Sample Code No file was uploaded with this report
pgsql-bugs@postgresql.org writes: > otdyh=# select to_date(20020200,'YYYYMMDD'); > to_date > ------------ > 2002-02-01 > must be 2002-01-31 !! > 00 day - is the last day of the previous month! I don't think so. If anything, this should raise an error. regards, tom lane