Cannot convert value '0000-00-00 00:00:00' from column 22 to TIMESTAMP
来源:互联网 发布:查看守望先锋数据 编辑:程序博客网 时间:2024/05/01 17:07
更改连接数据库方式
在连接:jdbc:mysql://127.0.0.1:3306/test 后面加上一个参数zeroDateTimeBehavior=convertToNull
即更改为:
jdbc:mysql://127.0.0.1:3306/test?zeroDateTimeBehavior=convertToNull
按照正常的做法,比如日期值为2016-10-11,但是由于误操作,传入了0000-00-00,并没有设置正确的数据,那么这时默认抛出java.sql.SQLException异常
(如果设定这一项 zero datetime behavior(英文字面意思为“0datetime反应”)=
convert to null(英文字面意思为“转化为null”)
,把日期转换为null代替异常处理):
即这类操作情况的处理策略,有3种
1.exception(不指定,则默认)---->默认抛出异常,
2.convertToNull------->转化为null
3.round------->替换成最近的日期即XXXX-01-01
这个在指定管理的数据库连接属性文件(jdbc.properties)jdbc的URL常用到:
比如这么写:
jdbc.url=jdbc:mysql://localhost:3306/databaseName?zeroDateTimeBehavior=convertToNull
阅读全文
0 0
- Cannot convert value '0000-00-00 00:00:00' from column 22 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.
- 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的解决办法
- 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分析及解决办法
- mysql错误: Cannot convert value ’0000-00-00 00:00:00′ from column 10 to TIMESTAMP
- Hibernate+EHCache配置二级缓存
- selenium+Chromedriver.exe的位置的设置
- HDU 5930GCD
- 物联网应用繁花似锦,LoRa和NB-IoT如何PK?
- BigDecimal 类型
- Cannot convert value '0000-00-00 00:00:00' from column 22 to TIMESTAMP
- MongoDB 关于MongoDB Shell的使用 (三)
- Apache 转发代理 IIS , 共用80端口
- Python知识点总结梳理
- Spring Cloud之Spring EL和AOP(3)
- 《An Algorithm for Subgraph Isomorphism》论文总结
- Jzoj5462【NOIP2017提高A组冲刺11.8】证书
- android 监听
- 关于DPR2.0&DPR3.0手机上的适配问题(focusdroid)