SQL批量修改日

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')