2
2
create table t1 (id int auto_increment primary key not null, mydate date not null);
3
insert into t1 values (0,"2002-05-01"),(0,"2002-05-01"),(0,"2002-05-01");
3
insert into t1 values (NULL,"2002-05-01"),(NULL,"2002-05-01"),(NULL,"2002-05-01");
5
5
select * from t1 where isnull(to_days(mydate));