Inserting temporal value in MySQL 5.7 or With the NO_ZERO_DATE SQL Mode Enabled Fails: "ERROR 1292 (22007): Incorrect datetime value: '0000-00-00 00:00:00' for column 'val' at row 1"
(Doc ID 2320951.1)
Last updated on SEPTEMBER 04, 2023
Applies to:
MySQL Server - Version 5.5 and laterInformation in this document applies to any platform.
Symptoms
When trying to insert a row - for example when restoring a mysqldump backup - into MySQL 5.7 or with the NO_ZERO_DATE SQL mode enabled, the following error occurs:
The data type mentioned in the error message depends on the data type of the column:
- For datetime and timestamp, the error says "Incorrect datetime value"
- For date, the error says "Incorrect date value"
Changes
The issue may for example start after upgrading to MySQL 5.7 or enabling the NO_ZERO_DATE SQL mode (enabled by default in MySQL 5.7 and later).
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |