27 January 2017

From version 5.7 MySQL stops supporting zeros value in date / datetime. If you have those values in your database you get errors for queries, like group by. Also you are not able to insert zero dates. When you need a fast fix and are not willing to change it for a NULL for an example. You can change it from mysql configuration file or run this query before you start your own queries.

Source code viewer
  1. SET SQL_MODE='';
Programming Language: MySQL