1--disable_warnings 2DROP TABLE IF EXISTS t3; 3--enable_warnings 4SET sql_mode='NO_ENGINE_SUBSTITUTION'; 5CREATE TABLE t3(c1 DATE NOT NULL); 6INSERT INTO t3 VALUES('1000-01-01 00:00:00'); 7INSERT INTO t3 VALUES('1999-12-31 23:59:59'); 8INSERT INTO t3 VALUES('2000-01-01 00:00:00'); 9INSERT INTO t3 VALUES('2008-02-29 13:13:13'); 10DROP TABLE t3; 11CREATE TABLE t3(c1 DATETIME NOT NULL); 12INSERT INTO t3 VALUES('1000-01-01 00:00:00'); 13INSERT INTO t3 VALUES('1999-12-31 23:59:59'); 14INSERT INTO t3 VALUES('2000-01-01 00:00:00'); 15INSERT INTO t3 VALUES('2008-02-29 13:13:13'); 16DROP TABLE t3; 17CREATE TABLE t3(c1 TIMESTAMP NOT NULL); 18INSERT INTO t3 VALUES('1000-01-01 00:00:00'); 19INSERT INTO t3 VALUES('1999-12-31 23:59:59'); 20INSERT INTO t3 VALUES('2000-01-01 00:00:00'); 21INSERT INTO t3 VALUES('2008-02-29 13:13:13'); 22DROP TABLE t3; 23CREATE TABLE t3(c1 TIME NOT NULL); 24INSERT INTO t3 VALUES('1000-01-01 00:00:00'); 25INSERT INTO t3 VALUES('1999-12-31 23:59:59'); 26INSERT INTO t3 VALUES('2000-01-01 00:00:00'); 27INSERT INTO t3 VALUES('2008-02-29 13:13:13'); 28DROP TABLE t3; 29SET sql_mode=default; 30