You specify day as a literal string, such as SATURDAY.Displays the date of the next Saturday after January 1, 2005: SQL> SELECT NEXT_DAY('01-JAN-2005', 'SATURDAY') FROM dual;NEXT_DAY(---------08-JAN-05SQL>