Multiple choice technology databases

What's the output select to_Date('2009-may-25','yyyymmdd') from dual

  1. 2009-may-25

  2. Error

  3. may-2009-25

  4. 200925may

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

The date format string 'yyyymmdd' is incompatible with the input '2009-may-25'. Month abbreviations like 'may' require format codes like 'mon' or 'month', not 'mm'. The mismatch causes Oracle to throw an error rather than attempt conversion.