Oracle NEXT_DAY function.

Preamble

Oracle/PLSQL NEXT_DAY function returns the first day of the week that is larger than date.

Oracle/PLSQL syntax of function NEXT_DAY

NEXT_DAY( date_id, weekday_id )

Parameters and function arguments

• date_id – used to search the next day of the week
• weekday_id – is the day of the week (it is: Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday)

The NEXT_DAY function returns date.

The NEXT_DAY function can be used in the following Oracle/PLSQL versions

Let’s consider some examples of the NEXT_DAY function and learn how to use NEXT_DAY function in Oracle.

SELECT NEXT_DAY('01.12.2014', 'Environment')
FROM DUAL;

--Result: 03.12.2014

SELECT NEXT_DAY('01.12.2014', 'Thursday')
FROM DUAL;

--Result: 04.12.2014

SELECT NEXT_DAY('01.12.2014', 'Friday')
FROM DUAL;

--Result: 05.12.2014

About Enteros

​​Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.​