EVOLUTION-MANAGER

Edit File: column_datetime_zero_month_day.result

DROP TABLE IF EXISTS timestamps; CREATE TABLE timestamps ( id INT PRIMARY KEY AUTO_INCREMENT, create_dt DATETIME ) DEFAULT CHARSET UTF8; INSERT INTO timestamps (create_dt) VALUES ("2012-00-01 00:00:00"); Warnings: Warning 1265 Data truncated for column 'create_dt' at row 1 INSERT INTO timestamps (create_dt) VALUES ("2012-01-00 00:00:00"); Warnings: Warning 1265 Data truncated for column 'create_dt' at row 1 SELECT * FROM timestamps; id create_dt 1 2012-01-01 00:00:00 2 2012-01-01 00:00:00 SELECT * FROM timestamps WHERE create_dt = "2012-01-01 00:00:00"; id create_dt 1 2012-01-01 00:00:00 2 2012-01-01 00:00:00 DROP TABLE timestamps;