Multiple choice technology programming languages

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. 03-JUL-00

  2. 10-JUL-00

  3. 11-JUL-00

  4. 17-JUL-00
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

NEXT_DAY(sysdate, 'MONDAY') finds the first Monday strictly after the current date. Since today is Monday, July 10, 2000, the next Monday is July 17, 2000. The to_char format 'DD-MON-RR' produces 17-JUL-00. Note that NEXT_DAY finds the NEXT occurrence, not the current day - if today is Monday, it returns the following Monday.

Keep practicing — related questions