Multiple choice technology databases

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

  1. 1/1/0051

  2. 1/1/1951

  3. 1/1/2051

  4. 1/1/9951

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

In Oracle SQL, the YY format specifier interprets two-digit years within a sliding window. The year '51' with YY format defaults to 2051 (current century for years 50-99). The RR format uses a different sliding window based on the current year, but YY simply uses the current century boundary.