NEXT_DAY(SYSDATE,'Monday'): Finding the first Monday after the current date and time
SQL>
SQL>
SQL> -- 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') "Next_Day" from DUAL;
Next_Day
----------------------
09/04/2006 07:09:24 PM
SQL>
Related examples in the same category