UPDATE fxkj_bottle_base a SET leave_date=DATE_FORMAT(a.leave_date,'%Y-%m-01'), final_date=DATE_FORMAT(a.final_date,'%Y-%m-01'), test_date=DATE_FORMAT(a.test_date,'%Y-%m-01'), test_final_date=DATE_FORMAT(a.test_final_date,'%Y-%m-01')