Add_Month:

  • It returns date after adding specifies number of months in to the given dates.
  • Syntax:
Add_Month (date, month);
  • Example:
SELECT add_Month (sysdate, 3) FROM DUAL ;
  • Output:
15-Aug-2016 ;

Last_Day:

  • It returns last day of the specified month.
  • Syntax:
last_day (date);

Example:

SELECT last_day (sysdate) FROM DUAL; 
  • Output:
31-May-2013

Months_Between:

  • It returns different between two dates in months.
  • Syntax:
months_between (date1, date2);
  • Example:
SELECT months_between ('10-Jan-2013','10-Nov-2012') FROM DUAL ;
  • Output:
2

Next_Day:

  • It displays date of the next upcoming day specified in to the second argument.
  • Syntax:
next_day (date, day);
  • Example:
SELECT next_day ('21-Jan-2013', 'Monday') FROM DUAL;
  • Output:
28-Jan-2013