Mysql query where condition with Date not equal to '0000-00-00'

Question

Iam trying to write a mysql query in which the where condition is (WHERE date !='0000-00-00'). But the query is not executing properly.

WHERE date != '0000-00-00'

Answer 1

First cast date to char. then try.

WHERE CAST(`date` AS CHAR(10)) != '0000-00-00'

OR

WHERE `date` != 0

OR

WHERE UNIX_TIMESTAMP(`date`) != 0

OR

WHERE `date` IS NOT NULL

OR

WHERE YEAR(`date`)=0