How to Get Next Month from Current Date in Oracle?

How to Get Next Month from Current Date in Oracle?

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.
  • SQL
  • 1 min read

Use add_months() function to get the next month from the current date in Oracle. Below are the examples:

Get Next Month's Date in Oracle

To simply get the next month date from the current date using the following SQL query:

Select add_months(sysdate, 1) from dual;

Output:

Today the date is 6th November 2022, so the output of the above SQL query would be 6th December 2022.

Get Next Month only from the Current Date

To get only the month name, use the to_char() function with the add_months() function. Below is an example:

Select to_char(add_months(sysdate, 1), 'MONTH') from dual;

Output:

DECEMBER

In the below example, it will only get the month number:

Select to_char(add_months(sysdate, 1), 'MM') from dual;

Output:

12

Related: