Next_day – Oracle SQL Function

NEXT_DAY returns the next day specified in the day_to_find argument from the date argument. day_to_find must be a string denoting a valid day of the week.

Syntax:

NEXT_DAY(date,day_to_find)

Example:

SELECT NEXT_DAY(’23-OCT-2004′,’FRIDAY’) AS RESULT FROM DUAL;

RESULT
—————-
29-OCT-2004 00:00:00