Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

The proper method to find the first Monday in a given month

SQL> SQL> SQL> SQL> -- The proper method to find the first Monday in a given month. SQL> SELECT TO_CHAR(NEXT_DAY('31-AUG-97','Monday'),'MM/DD/YYYY HH:MM:SS AM') "Next_Day" from DUAL; Next_Day ---------------------- 09/01/1997 12:09:00 AM SQL>