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
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
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
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;