Oracle ADD_MONTHS

Posted on 11.15.2011 by admin

Function Description

Function ADD_MONTHS returns the date PLUS or MINUS integer months.

Examples

SELECT ADD_MONTHS(SYSDATE, 1)
  FROM dual 

Result: 29.9.2011 10:24:48

SELECT ADD_MONTHS(SYSDATE, -1)
  FROM dual 

Result: 29.7.2011 10:26:35

This entry was posted in Oracle SQL Functions. Bookmark the permalink.