Equivalent function for DATEADD() in Oracle

The Solution to Equivalent function for DATEADD() in Oracle is


Method1: ADD_MONTHS

ADD_MONTHS(SYSDATE, -6)

Method 2: Interval

SYSDATE - interval '6' month

Note: if you want to do the operations from start of the current month always, TRUNC(SYSDATE,'MONTH') would give that. And it expects a Date datatype as input.

~ Answered on 2014-06-25 09:55:40


Most Viewed Questions: