Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

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>