BUG #1630: Wrong conversion in to_date() function. See example. - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      1630
Logged by:          Ariel E. Carná/Elizabeth Sosa
Email address:      acarna@tarifar.com
PostgreSQL version: 7.3.8/7.4.6
Operating system:   SuSE Linux
Description:        Wrong conversion in to_date() function. See example.
Details:

Case PgSQL 7.3.8/SuSE Linux 8.2 (i586)
======================================
PROD=# select to_date('2005-02-32', 'YYYY-MM-DD');
  to_date
------------
 2005-03-04
(1 row)

PROD=# select version();
                                                 version
----------------------------------------------------------------------------
-----------------------------
 PostgreSQL 7.3.8 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3
20030226 (prerelease) (SuSE Linux)
(1 row)


Case PgSQL 7.4.6/SuSE Linux 9.2
(i586)======================================
PROD=> select to_date('2005-02-32', 'YYYY-MM-DD');
  to_date
------------
 04-03-2005
(1 row)

PROD=> select version();
                                           version
----------------------------------------------------------------------------
-----------------
 PostgreSQL 7.4.6 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.4 (pre
3.3.5 20040809)
(1 row)