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)