Question

Changing year in MySQL date?

Answer 1

To change the year in MySQL date, you need to use DATE_FORMAT() function with UPDATE command. The syntax is as follows. Display all records from the table using select statement.