Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

Select next_day( date2001-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> --