For date or time columns ... enable one of the following SQL modes: mysql> SET sql_mode = 'STRICT_ALL_TABLES';mysql> SET sql_mode = 'STRICT_TRANS_TABLES'; For transactional tables, both modes ...