Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

The Proper Method to Find the First Monday in a Given Month

SQL>  SELECT TO_CHAR(NEXT_DAY('31-AUG-99','Monday'),'MM/DD/YYYY HH:MM:SS AM')   2       "Next_Day"   3   from DUAL; Next_Day ---------------------- 09/06/1999 12:09:00 AM SQL>