Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t3;
2 SET sql_mode='NO_ENGINE_SUBSTITUTION';
3 CREATE TABLE t3(c1 DATE NOT NULL);
4 INSERT INTO t3 VALUES('1000-01-01 00:00:00');
5 INSERT INTO t3 VALUES('1999-12-31 23:59:59');
6 Warnings:
7 Note 1265 Data truncated for column 'c1' at row 1
8 INSERT INTO t3 VALUES('2000-01-01 00:00:00');
9 INSERT INTO t3 VALUES('2008-02-29 13:13:13');
10 Warnings:
11 Note 1265 Data truncated for column 'c1' at row 1
12 DROP TABLE t3;
13 CREATE TABLE t3(c1 DATETIME NOT NULL);
14 INSERT INTO t3 VALUES('1000-01-01 00:00:00');
15 INSERT INTO t3 VALUES('1999-12-31 23:59:59');
16 INSERT INTO t3 VALUES('2000-01-01 00:00:00');
17 INSERT INTO t3 VALUES('2008-02-29 13:13:13');
18 DROP TABLE t3;
19 CREATE TABLE t3(c1 TIMESTAMP NOT NULL);
20 INSERT INTO t3 VALUES('1000-01-01 00:00:00');
21 Warnings:
22 Warning 1264 Out of range value for column 'c1' at row 1
23 INSERT INTO t3 VALUES('1999-12-31 23:59:59');
24 INSERT INTO t3 VALUES('2000-01-01 00:00:00');
25 INSERT INTO t3 VALUES('2008-02-29 13:13:13');
26 DROP TABLE t3;
27 CREATE TABLE t3(c1 TIME NOT NULL);
28 INSERT INTO t3 VALUES('1000-01-01 00:00:00');
29 Warnings:
30 Note 1265 Data truncated for column 'c1' at row 1
31 INSERT INTO t3 VALUES('1999-12-31 23:59:59');
32 Warnings:
33 Note 1265 Data truncated for column 'c1' at row 1
34 INSERT INTO t3 VALUES('2000-01-01 00:00:00');
35 Warnings:
36 Note 1265 Data truncated for column 'c1' at row 1
37 INSERT INTO t3 VALUES('2008-02-29 13:13:13');
38 Warnings:
39 Note 1265 Data truncated for column 'c1' at row 1
40 DROP TABLE t3;
41 SET sql_mode=default;