ARTICLES > SQL

[MYSQL] Update YEAR date only Turn Back

2018-06-12 11:09:12

UPDATE Table_name set Column_date = DATE_ADD (Column_date ,  INTERVAL 543 YEAR) WHERE YEAR(Column_date )=2018

Turn Back