NEXT_DAY

Returns a timestamp that represents the first weekday, named by expression that is later than the datetime-expression.

Example:

  SELECT NEXT_DAY('2000-04-24', 'TUESDAY')
FROM EMPLOYEE;

Returns '2000-04-25-00.00.00.000000,' which is the Tuesday following 04/24/2000.