Introduction:

In this tutorial, we are going to explain how to use Oracle NEXT_DAY function with basic syntax and many examples for better understanding.

NEXT_DAY returns the date of the next weekday specified.

Syntax:

NEXT_DAY(date, weekday)

Name	Description
date	The date you want to get next weekday to eg: sysdate.
weekday	The day of the week. It could be the full name of the day or abbreviation of first three letter of the day eg: SAT for Saturday and so on.

Applies to::

Oracle 19c, Oracle 18c, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i

Examples:

Let’s take some examples about Oracle NEXT_DAY and how to use it:

SELECT  NEXT_DAY ('12-JAN-2020', 'SAT')
FROM    DUAL;

SELECT  NEXT_DAY ('01-FEB-2020', 'SUNDAY')
FROM    DUAL;

Similar functions to Oracle NEXT_DAY:

ADD_MONTHS : Add number of months to a date.

In this tutorial, you have learned how to use the Oracle NEXT_DAY function to get the date of the next weekday which is later than a specified date.

Hopefully, it was clear and concise.