Oracle SQL - Write SQL to output which day of the week is 10,000 days after August 11, 1976?

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

Requirements

Write SQL to output which day of the week is 10,000 days after August 11, 1976?

Demo

SQL>
SQL> select to_char(date '1976-08-11' + 10000,'Day')
  2         as "On a:"
  3  from   dual;

On a:--   w  w w . j a v  a  2 s . com
---------
Sunday

SQL>

Related Quiz