Saturday, 13 April 2013

SQL Functions: ADD_MONTHS

ADD_MONTHS
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

Related Posts Plugin for WordPress, Blogger...

ShareThis