Zero date value prohibited
时间: 2023-11-29 17:49:17 浏览: 33
回答: 当遇到由0组成的日期时间值时,可以通过设置zeroDateTimeBehavior属性来处理。该属性可以设置为异常(exception)、近似值(round)或将该值转换为null(convertToNull)。默认情况下,该属性的值为异常(exception)。\[1\]\[2\]如果想要将该值转换为null,可以在连接字符串中添加zeroDateTimeBehavior=convertToNull参数。例如:jdbc:mysql://yourserver:3306/yourdatabase?zeroDateTimeBehavior=convertToNull。\[3\]这样就可以解决禁止使用零日期值的问题。
#### 引用[.reference_title]
- *1* *3* [SQLException: Zero date value prohibited解决方案](https://blog.csdn.net/qq_29229567/article/details/128664517)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insert_down1,239^v3^insert_chatgpt"}} ] [.reference_item]
- *2* [java.sql.SQLException: Zero date value prohibited](https://blog.csdn.net/a_starry_sky/article/details/111319741)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insert_down1,239^v3^insert_chatgpt"}} ] [.reference_item]
[ .reference_list ]