In MySQL 8.0, when using invalid values for date data types, an error is returned. This was not the case in 5.x versions. Let’s have a look using the table definition of bug 96361: CREATE TABLE `new_table` ( `id_table` int(11) NOT NULL AUTO_INCREMENT, `text_table` varchar(45) DEFAULT NULL, `date_table` date DEFAULT NULL, PRIMARY KEY (`id_table`) ) … Continue reading MySQL 8.0 and wrong dates