首页 > 代码库 > mysql timestamp字段定义的

mysql timestamp字段定义的

Cause: java.sql.SQLException: Cannot convert value ‘2017-07-26 20:40:41.000000‘ from column 10 to TIMESTAMP.
; SQL []; Cannot convert value ‘2017-07-26 20:40:41.000000‘ from column 10 to TIMESTAMP.; nested exception is java.sql.SQLException: Cannot convert value ‘2017-07-26 20:40:41.000000‘ from column 10 to TIMESTAMP.

字段长度为6,则显示为:2017-07-26 20:40:41.000000

字段长度为0,则显示为:2017-07-26 20:40:41

mysql timestamp字段 长度不一致导致数据查询时时间戳转换出错。

mysql timestamp字段定义的