MySQL 5.7

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

CREATE TABLE `some_table` (
    `date_exported` DATETIME NULL DEFAULT '0000-00-00 00:00:00'
);

Invalid default value for 'date_exported'

insert into some_table values (NULL);

Table 'fiddle.some_table' doesn't exist

select * from some_table WHERE date_exported IS NULL;

Table 'fiddle.some_table' doesn't exist