Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

NEXT_DAY(01-AUG-97,Monday)

SQL> SQL> SQL> -- Finding the first Monday in the month of August. SQL> SELECT TO_CHAR(NEXT_DAY('01-AUG-97','Monday'),'MM/DD/YYYY HH:MM:SS AM') "Next_Day" from DUAL; Next_Day ---------------------- 08/04/1997 12:08:00 AM SQL> SQL>