Nurlan Mukhanov (nurlan(at)otdyh(dot)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