Selecting min date excluding 0000-00-00

Question

I am running a query in SQL, and I need to select a minimum date that is not 0000-00-00. Is there any way to exclude this value and choose the next minimum date?

Answer 1

SELECT  MIN(mydate)
FROM    mytable
WHERE   mydate > '0000-00-00'

Answer 2

select min(date) from tbl where date > '0000-00-00'