Multiple choice technology databases

Assuming today is Friday, 28 August 2009, what is returned by this statement: SELECT to_char(NEXT_DAY(sysdate, 'FRIDAY'), 'DD-MON-RR') FROM dual;

  1. 21-AUG-09

  2. 28-AUG-09

  3. 04-SEP-09

  4. 29-AUG-09

  5. 27-AUG-09
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In Oracle SQL, NEXT_DAY returns the date of the first weekday named that is later than the given date. If today is Friday, NEXT_DAY(sysdate, 'FRIDAY') will return the following Friday, which is September 4th, 2009.

Keep practicing — related questions