Term: NEXT_DAY

Definition:
The Oracle NEXT_DAY function returns the date of the first weekday named by 'day_of_the_week' that is later than 'target_date'.

The return datatype is always DATE, regardless of the datatype of 'target_date'.
The argument 'day_of_the_week' must be a day of the week in the date language of your session, either the full name or the abbreviation. The minimum number of letters required is the number of letters in the abbreviated version.
The return value has the same hours, minutes, and seconds component as the argument date.

Example Syntax:

NEXT_DAY(target_date, day_of_the_week);

Example Usage:

This example returns the date of the next Friday after May 10, 2010:

SELECT NEXT_DAY('10-MAY-2010','FRIDAY') "NEXT DAY"

     FROM DUAL;



NEXT DAY

-----------

14-MAY-2010