SELECT `commencement_date`, 
UNIX_TIMESTAMP(NOW()) dt_now,
UNIX_TIMESTAMP('0000-00-00') ts_now,
UNIX_TIMESTAMP(STR_TO_DATE('0000-00-00', '%M %d %Y %h:%i%p'))

FROM `Y2019_floorplan_machines`
WHERE `commencement_date` = '0000-00-00';


(CASE date_created WHEN '0000-00-00 00:00:0' THEN NULL() ELSE UNIX_TIMESTAMP(STR_TO_DATE(date_created, '%M %d %Y %h:%i%p'))END) created_date,

(CASE commencement_date WHEN '0000-00-00' THEN NULL ELSE commencement_date END) commencement_date,