diff options
Diffstat (limited to 'mysql-test/main/type_temporal_mysql56.result')
-rw-r--r-- | mysql-test/main/type_temporal_mysql56.result | 89 |
1 files changed, 89 insertions, 0 deletions
diff --git a/mysql-test/main/type_temporal_mysql56.result b/mysql-test/main/type_temporal_mysql56.result new file mode 100644 index 00000000000..cdc951dac14 --- /dev/null +++ b/mysql-test/main/type_temporal_mysql56.result @@ -0,0 +1,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 +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; |