Date Timestamp Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Date Timestamp Functions
  4. 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>