mybatis的一个很奇怪的错误

Question

1、就是这段sql，as_senddate是varchar类型，

 UPDATE as_infos t SET t.as_status='22' WHERE (TO_DAYS(NOW()) -
        TO_DAYS(t.as_senddate)) >= 0 AND
        t.as_status='21'

2、直接在mysql中执行不报错，使用mybatis时报错。as_senddate的值不为空。
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: ''
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4094)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2734)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1379)

Answer 1

http://blog.csdn.net/wangjian5748/article/details/18923197