Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

Finding the First Monday After the Current Date and Time

SQL>  SELECT TO_CHAR(NEXT_DAY(SYSDATE,'Monday'),'MM/DD/YYYY HH:MM:SS AM')   2       "Next_Day"   3   from DUAL; Next_Day ---------------------- 06/04/2007 08:06:15 PM SQL>