Oracle SQL - Write SQL to output date for a given date plus 10,000 days?

  1. HOME
  2. Oracle SQL
  3. Select
  4. Default Date Time Constant Format

Requirements

Write SQL to output date for a given date plus 10,000 days?

Suppose the given date is August 11, 1976

Demo

SQL>
SQL>-- from   w w  w . j  ava 2 s  .c  om
SQL> select date '1976-08-11' + 10000
  2         as "10,000 days"
  3  from   dual;

10,000 da
---------
28-DEC-03

SQL>

Related Quiz