UPDATE `mm_Event` SET `ebDeadline` = DATE(`ebDeadline`) WHERE `ebDeadline` IS NOT NULL; UPDATE `mm_TradeShow` SET `ebDeadline` = DATE(`ebDeadline`) WHERE `ebDeadline` IS NOT NULL;