mariadb/mysql-test/suite/engines/funcs/r/time_function.result

10 lines
320 B
Text

DROP TABLE IF EXISTS t3;
CREATE TABLE t3(c1 TIME NOT NULL);
INSERT INTO t3 VALUES('00:00:00');
INSERT INTO t3 VALUES('23:59:59');
INSERT IGNORE INTO t3 VALUES('99:99:99');
Warnings:
Warning 1265 Data truncated for column 'c1' at row 1
INSERT INTO t3 VALUES('12:00:00');
INSERT INTO t3 VALUES('13:13:13');
DROP TABLE t3;