NEXT_DAY(x, day): get the date of the next day following x; : NEXT_DAY « Date Timestamp Functions « Oracle PL/SQL Tutorial






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

You specify day as a literal string, such as SATURDAY.

Displays the date of the next Saturday after January 1, 2005:

SQL> SELECT NEXT_DAY('01-JAN-2005', 'SATURDAY') FROM dual;

NEXT_DAY(
---------
08-JAN-05

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