Multiple choice technology databases

Answer the below query.. select to_date('01-01-51','DD-MM-RR') from dual

  1. 1/1/2051

  2. 1/1/1951

  3. 1/1/0051

  4. 1/1/9951

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Oracle's RR format uses a sliding window: if the last two digits of the current year are 00-49, then years 00-49 map to current century and 50-99 map to previous century. Assuming current year context where '51' falls in the 50-99 range, it maps to 1951. This is different from YY which would give 2051.