Finding the First Monday in the Month of August : NEXT_DAY « Date Timestamp Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Date Timestamp Functions
  3. NEXT_DAY
SQL> SELECT TO_CHAR(NEXT_DAY('01-AUG-99','Monday'),'MM/DD/YYYY HH:MM:SS AM')
  2       "Next_Day"
  3  from DUAL;

Next_Day
----------------------
08/02/1999 12:08:00 AM

SQL>








13.12.NEXT_DAY
13.12.1.NEXT_DAY(x, day): get the date of the next day following x;
13.12.2.next_day(sysdate,'SAT')
13.12.3.NEXT_DAY function
13.12.4.NEXT_DAY(start_date-1,'Tuesday')
13.12.5.Finding the First Monday in the Month of August
13.12.6.Finding the First Monday in the Month of September
13.12.7.The Proper Method to Find the First Monday in a Given Month