Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

NEXT_DAY(SYSDATE,Monday)

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>