MySQL 5.6 DATETIME不接受毫秒/微秒 [英] MySQL 5.6 DATETIME doesn't accept milliseconds/microseconds

问题描述

运行MySQL 5.6.7-rc，据称支持时间值的小数秒.是的...

Running MySQL 5.6.7-rc which allegedly supports fractional seconds in time values. Right...

在MySQL Workbench 5.2.44中尝试一下:

Try this in MySQL Workbench 5.2.44:

CREATE TABLE T (dt DATETIME);
INSERT INTO T (dt) VALUES ('2012-11-12 13:54:00.123');
SELECT dt FROM T;

输出是这样的:

2012-11-12 13:54:00

我在这里想念什么?

推荐答案

找到了答案.数据类型应为DATETIME(6)毫秒，DATETIME(3)毫秒.

Found the answer. Data type should be DATETIME(6) for microseconds and DATETIME(3) for milliseconds.

TIME和TIMESTAMP列类型还支持使用相同语法的小数秒.

TIME and TIMESTAMP column types also support fractional seconds with the same syntax.

有关更多信息，请参考 MySQL关于小数秒的参考.

For more information, consult the MySQL Reference on Fractional Seconds.

这篇关于MySQL 5.6 DATETIME不接受毫秒/微秒的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！