Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Select QueryRSS Feeds

Write a query to add and subtract months using add_months function

Posted By: Adalard Fischer     Category: Oracle     Views: 8013

Write a query to add and subtract months using add_months function.

Write a query to  Add and subtract months

SELECT add_months(SYSDATE,2),add_months(SYSDATE,-2) FROM DUAL;

Output : 

ADD_MONTH ADD_MONTH
26-JUN-97 26-FEB-97
  
Share: 

 
 
 


Adalard Fischer
Adalard Fischer author of Write a query to add and subtract months using add_months function is from Frankfurt, Germany.
 
View All Articles

 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!