NEXT_DAY is one of the vital Date/Time functions of Oracle. It is used to get the first weekday that is greater than the mentioned date. The NEXT_DAY function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i.
Syntax:
NEXT_DAY ( date, weekday )
Parameters:
date: It is used to specify the date.
weekday: It is used to specify the day of the week to be returned.
Example 1:
NEXT_DAY ( ‘26-JUN-19’, ‘SUNDAY’) |
Output:
‘30-AUG-19’
Explanation:
The result is the date of the first SUNDAY greater than the mentioned date.