# 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.