<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN" "http://www.wapforum.org/DTD/wml_1.1.xml">
<wml>
<head><meta forua="true" http-equiv="Cache-Control" content="max-age=0" /></head>
<card title="Mysql5.6出现时间问题Incorrect datetime value: '' for column 'createtime'" id="card1">
<p> 游客</p><p>
标题:Mysql5.6出现时间问题Incorrect datetime value: '' for column 'createtime'<br/>
正文:<br/>
今天部署服务器项目运行，当遇见有时间数据对象的插入和更新操作的时候，就报错，如下：Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: <br/>Incorrect datetime value: '' for column 'createtime' at row 1 at <br/>com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2868) at <br/>com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) at <br/>com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1160) at <br/>com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:685) at <br/>com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1400) at <br/>com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1314) at <br/>com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1299) at <br/>org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at <br/>org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at <br/>org.hibernate.id.Ident<br/><a href="http://camnpr.com/wap.asp?mode=WAP&amp;act=View&amp;id=1289&amp;Page=1">[&lt;&lt;]</a><a href="http://camnpr.com/wap.asp?mode=WAP&amp;act=View&amp;id=1289&amp;Page=1">[[1]]</a><a href="http://camnpr.com/wap.asp?mode=WAP&amp;act=View&amp;id=1289&amp;Page=2">[2]</a><a href="http://camnpr.com/wap.asp?mode=WAP&amp;act=View&amp;id=1289&amp;Page=2">[&gt;&gt;]</a><br/>
<br/>
<a href="wap.asp?act=Com&amp;id=1289">查看评论(0)</a><br/>
<a href="wap.asp?act=AddCom&amp;inpId=1289">发表评论</a><br/><br/>

<br/>

<br/>
<a href="http://camnpr.com/wap.asp">首页</a>
</p>
</card>
</wml>