Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

Select date 1996-01-29 + interval 1 month as col_1

SQL> SQL> select date '1996-01-29' + interval '1' month as col_1   2  from   dual; COL_1 --------- 29-FEB-96