ADD_MONTHS function in Teradata

ADD_MONTHS function takes two parameters, one is date from which you need to fetch the month and the number as how many months after you wan to fetch the data.

Syntax is :-

ADD_MONTHS( DATE, N)

Example is :-

SELECT ADD_MONTHS('2014-08-21',1) AFT_MNT;

2014-08-21SELECT ADD_MONTHS('2014-08-21',-1) BFR_MNT;

2014-07-21





Read Also:-  ADD_MONTHS function in Oracle