Multiple choice technology databases

Assuming today is Monday, 10 July 2000, what is returned by this statement: SELECT to_char(NEXT_DAY(sysdate, 'MONDAY'), 'DD-MON-RR') FROM dual;

  1. 17-JUL-00

  2. 11-JUL-00

  3. 09-JUL-00

  4. 03-JUL-00
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

NEXT_DAY(date, day) returns the date of the first specified day-of-week after the given date. Starting from Monday July 10, 2000, the NEXT MONDAY is July 17, 2000 (7 days later). The format mask DD-MON-RR produces '17-JUL-00'.

Keep practicing — related questions