Mega Code Archive
Finding the First Monday After the Current Date and Time
SQL> --
SQL>
SQL> SELECT TO_CHAR(NEXT_DAY(SYSDATE,'Monday'),'MM/DD/YYYY HH:MM:SS AM')
2 "Next_Day"
3 from DUAL;
Next_Day
----------------------
06/23/2008 06:06:08 PM
1 row selected.
SQL>
SQL> --