NEXT_DAY

Returns the first weekday that is greater than a date.

Syntax

NEXT_DAY( date, weekday )

Example

SELECT NEXT_DAY(TO_DATE('06-20-20 10:20:52', 'MM-DD-YY HH24:MI:SS'), 'WEDNESDAY')