ADD_MONTHS
This function is used to add integer months to existing date. The return data type is always date function.
This function is used to add integer months to existing date. The return data type is always date function.
SELECT
ADD_MONTHS (END_DATE, 1), emp FROM EMP;
Output: Returns one month after the END_DATE for
each item
No comments:
Post a Comment