Nurlan Mukhanov ([EMAIL PROTECTED]) 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
