1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
|
SHOW CREATE TABLE mysql56time;
Table Create Table
mysql56time CREATE TABLE `mysql56time` (
`t0` time DEFAULT NULL,
`t1` time(1) DEFAULT NULL,
`t2` time(2) DEFAULT NULL,
`t3` time(3) DEFAULT NULL,
`t4` time(4) DEFAULT NULL,
`t5` time(5) DEFAULT NULL,
`t6` time(6) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
SELECT * FROM mysql56time;
t0 838:59:59
t1 838:59:59.0
t2 838:59:59.00
t3 838:59:59.000
t4 838:59:59.0000
t5 838:59:59.00000
t6 838:59:59.000000
t0 00:00:00
t1 00:00:00.0
t2 00:00:00.00
t3 00:00:00.000
t4 00:00:00.0000
t5 00:00:00.00000
t6 00:00:00.000000
t0 -838:59:59
t1 -838:59:59.0
t2 -838:59:59.00
t3 -838:59:59.000
t4 -838:59:59.0000
t5 -838:59:59.00000
t6 -838:59:59.000000
DROP TABLE mysql56time;
SHOW CREATE TABLE mysql56datetime;
Table Create Table
mysql56datetime CREATE TABLE `mysql56datetime` (
`dt0` datetime DEFAULT NULL,
`dt1` datetime(1) DEFAULT NULL,
`dt2` datetime(2) DEFAULT NULL,
`dt3` datetime(3) DEFAULT NULL,
`dt4` datetime(4) DEFAULT NULL,
`dt5` datetime(5) DEFAULT NULL,
`dt6` datetime(6) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
SELECT * FROM mysql56datetime;
dt0 0000-00-00 00:00:00
dt1 0000-00-00 00:00:00.0
dt2 0000-00-00 00:00:00.00
dt3 0000-00-00 00:00:00.000
dt4 0000-00-00 00:00:00.0000
dt5 0000-00-00 00:00:00.00000
dt6 0000-00-00 00:00:00.000000
dt0 9999-12-31 23:59:59
dt1 9999-12-31 23:59:59.9
dt2 9999-12-31 23:59:59.99
dt3 9999-12-31 23:59:59.999
dt4 9999-12-31 23:59:59.9999
dt5 9999-12-31 23:59:59.99999
dt6 9999-12-31 23:59:59.999999
DROP TABLE mysql56datetime;
SET TIME_ZONE='+00:00';
SHOW CREATE TABLE mysql56timestamp;
Table Create Table
mysql56timestamp CREATE TABLE `mysql56timestamp` (
`ts0` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`ts1` timestamp(1) NOT NULL DEFAULT '0000-00-00 00:00:00.0',
`ts2` timestamp(2) NOT NULL DEFAULT '0000-00-00 00:00:00.00',
`ts3` timestamp(3) NOT NULL DEFAULT '0000-00-00 00:00:00.000',
`ts4` timestamp(4) NOT NULL DEFAULT '0000-00-00 00:00:00.0000',
`ts5` timestamp(5) NOT NULL DEFAULT '0000-00-00 00:00:00.00000',
`ts6` timestamp(6) NOT NULL DEFAULT '0000-00-00 00:00:00.000000'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
SELECT * FROM mysql56timestamp;
ts0 1970-01-01 00:00:01
ts1 1970-01-01 00:00:01.0
ts2 1970-01-01 00:00:01.00
ts3 1970-01-01 00:00:01.000
ts4 1970-01-01 00:00:01.0000
ts5 1970-01-01 00:00:01.00000
ts6 1970-01-01 00:00:01.000000
ts0 2038-01-19 03:14:07
ts1 2038-01-19 03:14:07.9
ts2 2038-01-19 03:14:07.99
ts3 2038-01-19 03:14:07.999
ts4 2038-01-19 03:14:07.9999
ts5 2038-01-19 03:14:07.99999
ts6 2038-01-19 03:14:07.999999
DROP TABLE mysql56timestamp;
|