MySQL将日期的时分秒置为0
update promotion_stage set
approve_end_time = concat(DATE_FORMAT(approve_end_time,'%Y-%m-%d'),' 00-00-00') ,
approve_start_time = concat(DATE_FORMAT(approve_start_time,'%Y-%m-%d'),' 00-00-00') ,
stage_end_time = concat(DATE_FORMAT(stage_end_time,'%Y-%m-%d'),' 00-00-00') ,
stage_start_time = concat(DATE_FORMAT(stage_start_time,'%Y-%m-%d'),' 00-00-00')