select next_day( date'2001-09-11', 'SUNDAY' ) : NEXT_DAY « Date Timezone « Oracle PL / SQL






select next_day( date'2001-09-11', 'SUNDAY' )

 
SQL>
SQL> select next_day( date'2001-09-11', 'SUNDAY' )
  2  from dual;
NEXT_DAY(
---------
16-SEP-01

1 row selected.

SQL>
SQL> --

 








Related examples in the same category

1.The proper method to find the first Monday in a given month
2.NEXT_DAY: the date of the day of the week following a particular date
3.Finding the first Monday in the month of September
4.NEXT_DAY('01-AUG-97','Monday'): Finding the first Monday in the month of August
5.NEXT_DAY(SYSDATE,'Monday'): Finding the first Monday after the current date and time
6.select next_day( date'2002-01-01', 'FRI' )