Changing only the year in a mysql date or datetime field Posted byDaniel Kurdoghlian July 2, 2016July 2, 2016 Leave a comment on Changing only the year in a mysql date or datetime field For a datetime-field: UPDATE table_name SET date_column=DATE_FORMAT(date_column,'2016-%m-%d %T'); For a date-field: UPDATE table_name SET date_column=DATE_FORMAT(date_column,'2016-%m-%d');