Syntax: DATE_ADD(date, INTERVAL value addunit) Example: SELECT DATE_ADD("2017-11-22", INTERVAL 3 YEAR); Output: 2020-11-22