NEXT_DAY function in Oracle

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.

Please follow and like us:
Content Protection by DMCA.com