Finding the first Monday in the month of September
SQL>
SQL>
SQL> -- Finding the first Monday in the month of September.
SQL> SELECT TO_CHAR(NEXT_DAY('01-SEP-97','Monday'),'MM/DD/YYYY HH:MM:SS AM') "Next_Day" from DUAL;
Next_Day
----------------------
09/08/1997 12:09:00 AM
SQL>
Related examples in the same category