Re: [BUGS] Bug #607: to_date() function bug

2002-03-04 Thread Tom Lane
[EMAIL PROTECTED] writes: > otdyh=# select to_date(20020200,'MMDD'); > 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 --

[BUGS] Bug #607: to_date() function bug

2002-03-04 Thread pgsql-bugs
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,'MMDD'); to_date 2002-02-01 must be 2002-01-31 !! Why??? 00 hours 0