Date Timestamp Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Date Timestamp Functions
  4. Finding the First Monday in the Month of August
SQL>  SELECT TO_CHAR(NEXT_DAY('01-AUG-99','Monday'),'MM/DD/YYYY HH:MM:SS AM')
  2       "Next_Day"
  3  from DUAL;
Next_Day
----------------------
08/02/1999 12:08:00 AM
SQL>