SQL>SQL>SQL> -- Finding the first Monday in the month of August.SQL> SELECT TO_CHAR(NEXT_DAY('01-AUG-97','Monday'),'MM/DD/YYYY HH:MM:SS AM') "Next_Day" from DUAL;Next_Day----------------------08/04/1997 12:08:00 AMSQL>SQL>