Add months to given date in oracle
By Santhosh N
This explains how to add the number of months to a given date in oracle
There is a function by the name, "Add_Months" which accepts two parameters
to add the given number of months to a date
Syntax: Add_Months(date, n)
Eg : Add_Months('10-Jan-2010', 5)
This outputs '10-Jun-2010'
Related FAQs
This explains how to retrieve the user id from the session in oracle
This explains how to retrieve the current session id of the user logged in
There is a table in oracle with the name V$TIMEZONE_NAMES where the timezone abbreviations and timezone names are availble
There are two ways to get the timezone information from oracle namely dbtimezone and sessiontimezone
Add months to given date in oracle (1220 Views)