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