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