报错信息：Data truncation: Incorrect date value: '2022-11-28T16:00:00.000Z' for column 'start_date' at row 1
报错原因：这里我是实体类的中日期定义为String类型，改成Date即可，Date类型对应数据库的datetime类型
Data truncation: Incorrect date value: ‘2022-11-28T16:00:00.000Z‘ for column ‘start_date‘ at row 1
2023-06-12
263
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《
阿里云开发者社区用户服务协议》和
《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写
侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
简介：
Data truncation: Incorrect date value: ‘2022-11-28T16:00:00.000Z‘ for column ‘start_date‘ at row 1
目录
相关文章
|
存储
SQL
关系型数据库
【MySQL异常】Row size too large (＞ 1982). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNA
【MySQL异常】Row size too large (＞ 1982). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNA
132
0
0
|
3月前
|
关系型数据库
MySQL
解决MySQL insert出现Incorrect datetime value: ‘0000-00-00 00:00:00‘ for column ‘xxx‘ at row 1
解决MySQL insert出现Incorrect datetime value: ‘0000-00-00 00:00:00‘ for column ‘xxx‘ at row 1
248
2
2
|
6月前
|
Python
完美解决丨ValueError: time data ‘2018/12/24‘ does not match format ‘%Y/%m/%d‘
完美解决丨ValueError: time data ‘2018/12/24‘ does not match format ‘%Y/%m/%d‘
198
0
0
|
SQL
关系型数据库
MySQL
[Err] 1294 - Invalid ON UPDATE clause for 'comment_time' column【详细解决办法】
[Err] 1294 - Invalid ON UPDATE clause for 'comment_time' column【详细解决办法】
731
0
0
![[Err] 1294 - Invalid ON UPDATE clause for 'comment_time' column【详细解决办法】](https://ucc.alicdn.com/pic/developer-ecology/9fd498965ed24738bf1bc5282eb8e073.jpg?x-oss-process=image/resize,h_160,m_lfit)
|
关系型数据库
MySQL
报错：Incorrect datetime value: '0000-00-00 00:00:00' for column 'login_time' at row 1
报错：Incorrect datetime value: '0000-00-00 00:00:00' for column 'login_time' at row 1
658
0
0
|
SQL
关系型数据库
MySQL
Incorrect table definition； there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT
Incorrect table definition； there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT
364
0
0
|
SQL
关系型数据库
MySQL
MySQL:[Err] 1292 - Incorrect datetime value: ‘0000-00-00 00:00:00‘ for column ‘CREATE_TIME‘ at row 1
MySQL:[Err] 1292 - Incorrect datetime value: ‘0000-00-00 00:00:00‘ for column ‘CREATE_TIME‘ at row 1
1173
0
0
![MySQL:[Err] 1292 - Incorrect datetime value: ‘0000-00-00 00:00:00‘ for column ‘CREATE_TIME‘ at row 1](https://ucc.alicdn.com/pic/developer-ecology/d43b8117be9a46b8926cedcea0faaac0.png?x-oss-process=image/resize,h_160,m_lfit)
|
SQL
Java
数据库连接
JPA异常：Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
JPA异常：Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
2030
0
0
|
关系型数据库
MySQL
1293 - Incorrect table definition; there can be only oneTIMESTAMP column with CURRENT_TIMESTAMP
一个表中出现多个timestamp并设置其中一个为current_timestamp的时候经常会遇到
1293 - Incorrect table definition; there can be only oneTIME...
2475
0
0
|
Web App开发
Java
关系型数据库
Data truncation: Data too long for column 'xxx' at row 1
Data truncation: Data too long for column 'xxx' at row 1
完整的错误内容可能是下面这样的：
p.p1 {margin: 0.0px 0.0px 0.
2242
0
0