Oracle›Date/Time Functions›NEXT_DAY
←LAST_DAY

NEXT_DAYDate/Time Functions

ROUND→

Returns the next occurrence of the specified weekday.

Syntax

NEXT_DAY(date, weekday)

Example

Enter values below to update the example in real time.

next_monday→
-- 다음 월요일 날짜
SELECT NEXT_DAY(SYSDATE, '월요일') AS next_monday FROM DUAL;