MYSQL:Cannot convert value '0000-00-00 00:00:00' from column 10 to TIMESTAMP的解决办法
来源:互联网 发布:淘宝网站的盈利模式 编辑:程序博客网 时间:2024/05/01 14:16
今天从MYSQL数据库抓取时,发生了Cannot convert value '0000-00-00 00:00:00' from column 10 to TIMESTAMP异常
baidu了一下,大概意思是MySQL中的Datetime值无法再JAVA中可靠的被表示,按照JDBC和SQL的标准默认情况下产生异常。
JDBC允许用下列的值对zeroDateTimeBehavior 属性来设置这些处理方式,
exception (the default), which throws an SQLException with an SQLState of S1009.
设置为exception 异常(缺省)用一个SQLState的s1009错误号来抛出一个异常
convertToNull, which returns NULL instead of the date.
设置为convertToNull,用NULL值来代替这个日期类型
round, which rounds the date to the nearest closest value which is 0001-01-01.
设置为round,则围绕这个日期最接近的值(0001-01-01)来代替
你可以修改你的jdbc连接
jdbc:mysql://localhost:3306/NovelSiteDB?user=root&password=123456&zeroDateTimeBehavior=round
0 0
- 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
- 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分析及解决办法
- 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的JDBC连接mysql数据库时对于Datetime类型出现Cannot convert value '0000-00-00 00:00:00' from column 9 to TIMESTAMP.
- 双边滤波和引导滤波的原理
- 【discuz x3】home_follow.php(广播页面)中$alist = getfollowfeed($vuid, $view, true, $start, $perpage);结果
- 轻曲书辞,伏案杯空逍遥
- iOS小效果(0)按钮控制图片的移动的方向
- python3.X中pickle类的用法(cPickle模块移除了)
- MYSQL:Cannot convert value '0000-00-00 00:00:00' from column 10 to TIMESTAMP的解决办法
- 常用正则表达式
- 黑马程序员_Properties
- Android Launcher分析和修改1——Launcher默认界面配置(default_workspace)
- iOS设计模式学习实例
- SQLServer的数据类型
- web程序帮助文档
- hdu Max Sum Plus Plus
- 轻曲书辞,伏案杯空逍遥