For date or time columns, illegal values are converted to the appropriate “zero†value for the type (see Table 3.15). ... mysql> SET sql_mode = 'STRICT_ALL_TABLES'; ...