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字段 长度不一致导致数据查询时时间戳转换出错。

posted on 2017-07-26 22:06  张释文  阅读(310)  评论(0编辑  收藏  举报