NEXT_DAY function : NEXT_DAY « Date Timestamp Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Date Timestamp Functions
  3. NEXT_DAY

The NEXT_DAY function returns the date of the day of the week following a particular date.

"day of the week" is expressed as the day written out (like Monday, Tuesday, etc.).

SQL>
SQL> SELECT NEXT_DAY(TO_DATE('15SEP2006','DDMONYYYY'),'Monday') FROM dual;

NEXT_DAY(
---------
18-SEP-06








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