Introducing Radical.sh

Forget Code launches a powerful code generator for building API's

Add months in Informatica in Informatica

  1. Forget Code
  2. Informatica
  3. Add months in Informatica
Add months in informatica 
ADD_TO_DATE( DATE_SHIPPED, 'MM', 1 )

DATE_SHIPPEDRETURN VALUE
Jan 1 1997 12:00:30AMFeb 01 1997 12:00:30AM


Subtract Months in informatica 
ADD_TO_DATE( DATE_SHIPPED, 'MM', -1 )

DATE_SHIPPEDRETURN VALUE
Jan 1 1997 12:00:30AMDec 01 1996 12:00:30AM