mysql-ctod string to date

 select IF(ISNULL(EOL),STR_TO_DATE('01/01/1753', '%m/%d/%Y'),eol) FROM PRODUCT;