ADD YEARS in Teradata

INTERVAL function will help in adding the years.
Day and month values will be unaffected.

Syntax:
SELECT DATE + INTERVAL 'n' YEAR;


SELECT DATE '1998-08-31' + INTERVAL '1' YEAR;
08/31/1999


SELECT DATE '2012-01-31' + INTERVAL '3' YEAR;
01/31/2015


SELECT DATE '2012-01-31' + INTERVAL '6' YEAR;
01/31/2018