MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

set session sql_mode = ''
CREATE TABLE `users` (
 `created_in` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
insert into users values ('')
select * from users


created_in


0000-00-00


set session sql_mode = 'STRICT_ALL_TABLES'
insert into users values ('')
Incorrect date value: '' for column 'created_in' at row 1