1 DROP TABLE IF EXISTS t3;
2 CREATE TABLE t3(c1 DATE NOT NULL);
3 INSERT INTO t3 VALUES('1000-01-01 00:00:00');
4 INSERT INTO t3 VALUES('1999-12-31 23:59:59');
6 Note 1265 Data truncated for column 'c1' at row 1
7 INSERT INTO t3 VALUES('2000-01-01 00:00:00');
8 INSERT INTO t3 VALUES('2008-02-29 13:13:13');
10 Note 1265 Data truncated for column 'c1' at row 1
12 CREATE TABLE t3(c1 DATETIME NOT NULL);
13 INSERT INTO t3 VALUES('1000-01-01 00:00:00');
14 INSERT INTO t3 VALUES('1999-12-31 23:59:59');
15 INSERT INTO t3 VALUES('2000-01-01 00:00:00');
16 INSERT INTO t3 VALUES('2008-02-29 13:13:13');
18 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
19 INSERT INTO t3 VALUES('1000-01-01 00:00:00');
21 Warning 1264 Out of range value for column 'c1' at row 1
22 INSERT INTO t3 VALUES('1999-12-31 23:59:59');
23 INSERT INTO t3 VALUES('2000-01-01 00:00:00');
24 INSERT INTO t3 VALUES('2008-02-29 13:13:13');
26 CREATE TABLE t3(c1 TIME NOT NULL);
27 INSERT INTO t3 VALUES('1000-01-01 00:00:00');
28 INSERT INTO t3 VALUES('1999-12-31 23:59:59');
29 INSERT INTO t3 VALUES('2000-01-01 00:00:00');
30 INSERT INTO t3 VALUES('2008-02-29 13:13:13');