Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

Select date 1954-08-11 + 10000 as 10,000 days

SQL> SQL> select date '1954-08-11' + 10000 as "10,000 days"   2  from   dual; 10,000 da --------- 27-DEC-81 SQL>