Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

Select next_day( date2002-01-01, FRI )

SQL> SQL> select next_day( date'2002-01-01', 'FRI' )   2  from dual; NEXT_DAY( --------- 04-JAN-02 1 row selected. SQL> SQL> --