Debian Codegraph @

mysql-test/suite/engines/funcs/r/datetime_function.result

raw
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');
5 Warnings:
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');
9 Warnings:
10 Note 1265 Data truncated for column 'c1' at row 1
11 DROP TABLE t3;
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');
17 DROP TABLE t3;
18 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
19 INSERT IGNORE INTO t3 VALUES('1000-01-01 00:00:00');
20 Warnings:
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');
25 DROP TABLE t3;
26 CREATE TABLE t3(c1 TIME NOT NULL);
27 INSERT INTO t3 VALUES('1000-01-01 00:00:00');
28 Warnings:
29 Note 1265 Data truncated for column 'c1' at row 1
30 INSERT INTO t3 VALUES('1999-12-31 23:59:59');
31 Warnings:
32 Note 1265 Data truncated for column 'c1' at row 1
33 INSERT INTO t3 VALUES('2000-01-01 00:00:00');
34 Warnings:
35 Note 1265 Data truncated for column 'c1' at row 1
36 INSERT INTO t3 VALUES('2008-02-29 13:13:13');
37 Warnings:
38 Note 1265 Data truncated for column 'c1' at row 1
39 DROP TABLE t3;