mysql 5.6中的时间类型的新精度
在mysql 5.6中,time,timestamp,datetime都可以精确到微妙,并指定微秒的精确度了,
比如如下的例子:
CREATE TABLE `t` (
`id` int(11) AUTO_INCREMENT,
`t1` time(3),
`t2` timestamp(6),
`t3` datetime(1),
`t4` datetime,
PRIMARY KEY (`id`)
) ENGINE=InnoDB
mysql> select * from t;
+—-+————–+—————————-+———————–+———————+
| id | t1 | t2 | t3 | t4 |
+—-+————–+—————————-+———————–+———————+
| 1 | 05:05:10.000 | 2013-07-04 05:05:10.000000 | 2013-07-04 05:05:10.0 | 2013-07-04 05:05:10 |
| 2 | 05:14:24.414 | 2013-07-04 05:14:24.125000 | 2013-07-04 05:14:24.4 | 2013-07-04 05:14:25 |
| 3 | 05:14:32.566 | 2013-07-04 05:14:32.207031 | 2013-07-04 05:14:32.3 | 2013-07-04 05:14:32 |
| 4 | 05:14:34.344 | 2013-07-04 05:14:34.507813 | 2013-07-04 05:14:34.5 | 2013-07-04 05:14:35 |
| 5 | 05:14:45.348 | 2013-07-04 05:14:45.832031 | 2013-07-04 05:14:45.1 | 2013-07-04 05:14:45 |
其中,在http://dev.mysql.com/doc/internals/en/date-and-time-data-type-representation.html中对mysql 5.6中的日期存储位数有了新的解析论述
