1DROP TABLE IF EXISTS t1,t2,t3; 2SET sql_mode='NO_ENGINE_SUBSTITUTION'; 3SET TIME_ZONE="+03:00"; 4CREATE TABLE t1(c1 DATE NOT NULL); 5SET TIMESTAMP=1171346973; 6INSERT INTO t1 (c1) VALUES(NOW()); 7Warnings: 8Note 1265 Data truncated for column 'c1' at row 1 9INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01')); 10Warnings: 11Note 1265 Data truncated for column 'c1' at row 1 12INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'2 02:01:01')); 13Warnings: 14Note 1265 Data truncated for column 'c1' at row 1 15INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'3 03:01:01')); 16Warnings: 17Note 1265 Data truncated for column 'c1' at row 1 18INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'4 04:01:01')); 19Warnings: 20Note 1265 Data truncated for column 'c1' at row 1 21SELECT * FROM t1 ORDER BY c1; 22c1 232007-02-13 242007-02-14 252007-02-15 262007-02-16 272007-02-17 28UPDATE t1 SET c1 = NOW() WHERE c1 >= ADDTIME(NOW(),'2 02:01:01'); 29Warnings: 30Note 1265 Data truncated for column 'c1' at row 4 31Note 1265 Data truncated for column 'c1' at row 5 32SELECT * FROM t1 ORDER BY c1; 33c1 342007-02-13 352007-02-13 362007-02-13 372007-02-14 382007-02-15 39DROP TABLE t1; 40CREATE TABLE t1(c1 TIME NOT NULL); 41SET TIMESTAMP=1171346973; 42INSERT INTO t1 (c1) VALUES(NOW()); 43INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01')); 44INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'2 02:01:01')); 45INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'3 03:01:01')); 46INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'4 04:01:01')); 47SELECT * FROM t1 ORDER BY c1; 48c1 4909:09:33 5010:10:34 5111:10:34 5212:10:34 5313:10:34 54UPDATE t1 SET c1 = NOW() WHERE c1 >= ADDTIME(NOW(),'2 02:01:01'); 55SELECT * FROM t1 ORDER BY c1; 56c1 5709:09:33 5809:09:33 5909:09:33 6009:09:33 6110:10:34 62DROP TABLE t1; 63CREATE TABLE t1(c1 DATETIME NOT NULL); 64SET TIMESTAMP=1171346973; 65INSERT INTO t1 (c1) VALUES(NOW()); 66INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01')); 67INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'2 02:01:01')); 68INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'3 03:01:01')); 69INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'4 04:01:01')); 70SELECT * FROM t1 ORDER BY c1; 71c1 722007-02-13 09:09:33 732007-02-14 10:10:34 742007-02-15 11:10:34 752007-02-16 12:10:34 762007-02-17 13:10:34 77UPDATE t1 SET c1 = NOW() WHERE c1 >= ADDTIME(NOW(),'2 02:01:01'); 78SELECT * FROM t1 ORDER BY c1; 79c1 802007-02-13 09:09:33 812007-02-13 09:09:33 822007-02-13 09:09:33 832007-02-13 09:09:33 842007-02-14 10:10:34 85DROP TABLE t1; 86CREATE TABLE t1(c1 TIMESTAMP NOT NULL); 87SET TIMESTAMP=1171346973; 88INSERT INTO t1 (c1) VALUES(NOW()); 89INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01')); 90INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'2 02:01:01')); 91INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'3 03:01:01')); 92INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'4 04:01:01')); 93SELECT * FROM t1 ORDER BY c1; 94c1 952007-02-13 09:09:33 962007-02-14 10:10:34 972007-02-15 11:10:34 982007-02-16 12:10:34 992007-02-17 13:10:34 100UPDATE t1 SET c1 = NOW() WHERE c1 >= ADDTIME(NOW(),'2 02:01:01'); 101SELECT * FROM t1 ORDER BY c1; 102c1 1032007-02-13 09:09:33 1042007-02-13 09:09:33 1052007-02-13 09:09:33 1062007-02-13 09:09:33 1072007-02-14 10:10:34 108DROP TABLE t1; 109SET TIME_ZONE= @@global.time_zone; 110SET sql_mode=default; 111