MYSQL-IIF

Select
if(terminationdate='0000-00-00' or ISNULL(terminationDATE),'',terminationdate) TERMINATIONDATE  from employee;