101
101
t8 timestamp(8), t10 timestamp(10), t12 timestamp(12),
102
102
t14 timestamp(14));
104
Warning 1287 The syntax 'TIMESTAMP(2)' is deprecated and will be removed in MySQL 5.2. Please use 'TIMESTAMP' instead
105
Warning 1287 The syntax 'TIMESTAMP(4)' is deprecated and will be removed in MySQL 5.2. Please use 'TIMESTAMP' instead
106
Warning 1287 The syntax 'TIMESTAMP(6)' is deprecated and will be removed in MySQL 5.2. Please use 'TIMESTAMP' instead
107
Warning 1287 The syntax 'TIMESTAMP(8)' is deprecated and will be removed in MySQL 5.2. Please use 'TIMESTAMP' instead
108
Warning 1287 The syntax 'TIMESTAMP(10)' is deprecated and will be removed in MySQL 5.2. Please use 'TIMESTAMP' instead
109
Warning 1287 The syntax 'TIMESTAMP(12)' is deprecated and will be removed in MySQL 5.2. Please use 'TIMESTAMP' instead
110
Warning 1287 The syntax 'TIMESTAMP(14)' is deprecated and will be removed in MySQL 5.2. Please use 'TIMESTAMP' instead
104
Warning 1287 The syntax 'TIMESTAMP(2)' is deprecated and will be removed in MySQL 6.0. Please use 'TIMESTAMP' instead
105
Warning 1287 The syntax 'TIMESTAMP(4)' is deprecated and will be removed in MySQL 6.0. Please use 'TIMESTAMP' instead
106
Warning 1287 The syntax 'TIMESTAMP(6)' is deprecated and will be removed in MySQL 6.0. Please use 'TIMESTAMP' instead
107
Warning 1287 The syntax 'TIMESTAMP(8)' is deprecated and will be removed in MySQL 6.0. Please use 'TIMESTAMP' instead
108
Warning 1287 The syntax 'TIMESTAMP(10)' is deprecated and will be removed in MySQL 6.0. Please use 'TIMESTAMP' instead
109
Warning 1287 The syntax 'TIMESTAMP(12)' is deprecated and will be removed in MySQL 6.0. Please use 'TIMESTAMP' instead
110
Warning 1287 The syntax 'TIMESTAMP(14)' is deprecated and will be removed in MySQL 6.0. Please use 'TIMESTAMP' instead
111
111
insert t1 values (0,0,0,0,0,0,0),
112
112
("1997-12-31 23:47:59", "1997-12-31 23:47:59", "1997-12-31 23:47:59",
113
113
"1997-12-31 23:47:59", "1997-12-31 23:47:59", "1997-12-31 23:47:59",
492
492
5 NULL 2001-09-09 04:46:59
493
493
6 NULL 2006-06-06 06:06:06
495
496
set time_zone= @@global.time_zone;
496
497
CREATE TABLE t1 (
497
498
`id` int(11) NOT NULL auto_increment,
512
CREATE TABLE t1 ( f1 INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
513
f2 TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
515
INSERT INTO t1 (f2,f3) VALUES (NOW(), "0000-00-00 00:00:00");
516
INSERT INTO t1 (f2,f3) VALUES (NOW(), NULL);
517
INSERT INTO t1 (f2,f3) VALUES (NOW(), ASCII(NULL));
518
INSERT INTO t1 (f2,f3) VALUES (NOW(), FROM_UNIXTIME('9999999999'));
519
INSERT INTO t1 (f2,f3) VALUES (NOW(), TIME(NULL));
520
UPDATE t1 SET f2=NOW(), f3=FROM_UNIXTIME('9999999999') WHERE f1=1;
521
SELECT f1,f2-f3 FROM t1;