Pedro, I'm tired of the Feb 30 date problem reference and I'm going to debunk this once and for all. It was only for old versions of MySQL and those versions are nearing end of life.
Look here: mysql> set SQL_MODE='STRICT_ALL_TABLES'; Query OK, 0 rows affected (0.23 sec) mysql> insert into testdate values ('2007-02-30'); ERROR 1292 (22007): Incorrect date value: '2007-02-30' for column 'testdate' at row 1 mysql> insert into testdate values ('2007-02-29'); ERROR 1292 (22007): Incorrect date value: '2007-02-29' for column 'testdate' at row 1 mysql> insert into testdate values ('2007-02-28'); Query OK, 1 row affected (0.00 sec) mysql> select * from testdate; +------------+ | testdate | +------------+ | 2007-02-28 | +------------+ 1 row in set (0.01 sec) Done with this. Gerry _______________________________________________ Tinyerp-users mailing list http://tiny.be/mailman/listinfo/tinyerp-users
