Обсуждение: 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