关于mysql的日期时间类型

[kissjhy]

20150824 093115.697
年月日 HHMMSS 毫秒
请教：我的数据时间格式是这样的
小数点后为毫秒
mysql该选择什么数据类型啊？

[benluobo]

A DATETIME or TIMESTAMP value can include a trailing fractional seconds part in up to microseconds (6 digits) precision. In particular, as of MySQL 5.6.4, any fractional part in a value inserted into a DATETIME or TIMESTAMP column is stored rather than discarded. With the fractional part included, the format for these values is 'YYYY-MM-DD HH:MM:SS[.fraction]', the range for DATETIME values is '1000-01-01 00:00:00.000000' to '9999-12-31 23:59:59.999999', and the range for TIMESTAMP values is '1970-01-01 00:00:01.000000' to '2038-01-19 03:14:07.999999'. The fractional part should always be separated from the rest of the time by a decimal point; no other fractional seconds delimiter is recognized. For information about fractional seconds support in MySQL, see Section 11.3.6, “Fractional Seconds in Time Values”.

[道玄希言]

既然你保存的是时间， 可以直接用 DATETIME 的， 这样对于你以后查询啊什么的， 都会方便很多了。

如果你一定要表示成  20150824 093115.697  这样， 那用varchar(19)  可以保存。

但是到之后要用这个字段做条件进行条件查询，或者统计啥的，就有你受的了。

[kissjhy]

引用 1 楼 benluobobo 的回复:

A DATETIME or TIMESTAMP value can include a trailing fractional seconds part in up to microseconds (6 digits) precision. In particular, as of MySQL 5.6.4, any fractional part in a value inserted into a DATETIME or TIMESTAMP column is stored rather than discarded. With the fractional part included, the format for these values is 'YYYY-MM-DD HH:MM:SS[.fraction]', the range for DATETIME values is '1000-01-01 00:00:00.000000' to '9999-12-31 23:59:59.999999', and the range for TIMESTAMP values is '1970-01-01 00:00:01.000000' to '2038-01-19 03:14:07.999999'. The fractional part should always be separated from the rest of the time by a decimal point; no other fractional seconds delimiter is recognized. For information about fractional seconds support in MySQL, see Section 11.3.6, “Fractional Seconds in Time Values”.

谢谢，文档出自哪里？

[benluobo]

mysql 5.6 官方开发文档

[ACMAIN_CHM]

varchar

[侯爵123]

varchar

[Rotel-刘志东]

用varchar