mysql错误: Cannot convert value '0000-00-00 00:00:00' from column 10 to TIMESTAMP
来源:互联网 发布:手机管理照片 知乎 编辑:程序博客网 时间:2024/05/01 07:02
问题:MySQL数据库,如果数据库中日期字段为空为值为'0000-00-00 00:00:00"时,查询的时候回报:Cannot convert value '0000-00-00 00:00:00' from column 10 to TIMESTAMP
解决办法:
更改连接数据库方式
在连接:jdbc:mysql://127.0.0.1:3306/test 后面加上一个参数zeroDateTimeBehavior=convertToNull
即更改为:
jdbc:mysql://127.0.0.1:3306/test?zeroDateTimeBehavior=convertToNull
问题就解决了。
网上看到的一个很好的答案网址:http://www.bennadel.com/blog/1434-MySQL-Cannot-Convert-Value-0000-00-00-00-00-00-From-Column-XX-To-TIMESTAMP.htm
- mysql错误: Cannot convert value '0000-00-00 00:00:00' from column 10 to TIMESTAMP
- mysql错误: Cannot convert value ’0000-00-00 00:00:00′ from column 10 to TIMESTAMP
- MYSQL:Cannot convert value '0000-00-00 00:00:00' from column 10 to TIMESTAMP的解决办法
- Cannot convert value '0000-00-00 00:00:00' from column 1 to TIMESTAMP
- Cannot convert value '0000-00-00 00:00:00' from column 1 to TIMESTAMP
- Cannot convert value '0000-00-00 00:00:00' from column 1 to TIMESTAMP
- Cannot convert value '0000-00-00 00:00:00' from column 1 to TIMESTAMP .
- Cannot convert value '0000-00-00 00:00:00' from column 1 to TIMESTAMP
- Cannot convert value '0000-00-00 00:00:00' from column 1 to TIMESTAMP
- Cannot convert value '0000-00-00 00:00:00' from column 1 to TIMESTAMP
- Hibernate Cannot convert value '0000-00-00 00:00:00' from column 5 to TIMESTAMP
- Cannot convert value '0000-00-00 00:00:00' from column 1 to TIMESTAMP
- 开发 - Cannot convert value '0000-00-00 00:00:00' from column 38 to TIMESTAMP.
- Cannot convert value '0000-00-00 00:00:00' from column 22 to TIMESTAMP
- spring mvc 查询报错Cannot convert value '0000-00-00' from column 20 to TIMESTAMP
- java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 7 to TIMESTAMP
- java.Sql.Exception:Cannot convert value '0000-00-00 00:00:00' from column 13 to TIMESTAMP的解决办法
- Cannot convert value '0000-00-00 00:00:00' from column 1 to TIMESTAMP分析及解决办法
- 运用jQuery实现的图片浏览器
- PHP模拟实现Java的endsWith
- 控件随着窗口大小变化
- 成为Oracle DBA最基本的十步
- Request.UrlReferrer注意
- mysql错误: Cannot convert value '0000-00-00 00:00:00' from column 10 to TIMESTAMP
- 关于SVN 使用中的一些小技巧
- Oracle Database中DBA常用的表和视图
- 在VS2008中创建自定义控件(七)自定义控件的中常用到的特性
- SilverLight中datagrid数据绑定的简单使用
- 面向对象讲解(二)
- 单选框取值--radio value
- Apache Commons工具集简介
- 一次网上招聘经过