#1292 – Incorrect date value: ‘0000-00-00’ [duplicate]

by

The error is because of the sql mode which can be strict mode as per latest MYSQL 5.7 documentation.

To disable strict mode and other strict features, run this query:

SET GLOBAL sql_mode="";

For more information read this.

Hope it helps.

More Related Contents:

  1. i have an error which i dont understand. can you help me? [closed]
  2. If two columns are 1 then make new column
  3. Left Outer Join doesn’t return all rows from my left table?
  4. Get a list of dates between two dates
  5. How to populate a table with a range of dates?
  6. MySQL Query GROUP BY day / month / year
  7. Error in MySQL when setting default value for DATE or DATETIME
  8. MySQL : isn’t in GROUP BY
  9. MySQL: Can’t create table (errno: 150)
  10. Difference between two dates in MySQL
  11. Restore table structure from frm and ibd files
  12. Subqueries with EXISTS vs IN – MySQL
  13. Get the latest date from grouped MySQL data
  14. Error Dropping Database (Can’t rmdir ‘.test\’, errno: 17)
  15. How to select the most recent set of dated records from a mysql table
  16. Composite key as foreign key (sql)
  17. Compare only day and month with date field in mysql
  18. Insert/ Update random date in MySQL
  19. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  20. mySQL query to search all tables within a database for a string?
  21. How do I extract Month and Year in a MySQL date and compare them?
  22. Getting first day of the week in MySql using Week No
  23. Can’t import database through phpmyadmin file size too large
  24. Update MySQL with if condition
  25. “Unknown column in ‘field list'”, but column does exist
  26. How do I combine the results of two queries with ordering?
  27. How to get back Lost phpMyAdmin Password, XAMPP
  28. UTF8 problem with MySQL 5
  29. ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
  30. MYSQL Select One Random record from each Category

Leave a Comment