Multiple choice technology programming languages

You need to display the date ll-oct-2007 in words as "Eleventh of October, Two Thousand Seven'. Which SQL statement would give the required result?

  1. SELECT TO_CHAR('ll-oct-2007'. 'miDdspth "of Month. Year') FROM DUAL:

  2. SELECT TO_CHAR(TO_DATE('ll-oct-2007'X 'miDdspth of month, year') FROM DUAL;

  3. SELECT TO_CHAR(TO_DATE('ll-oct-2007'). 'miDdthsp "of* Month. Year') FROM DUAL;

  4. SELECT TO_DATE(TO_CHAR('ll-oct-20077fiiiDdspth "of" Month. Year')) FROM DUAL:
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The correct approach uses TO_CHAR with TO_DATE to first parse the string into a date, then format it. The format model uses 'ddspth' for ordinal day number, 'Month' for full month name, and 'year' for spelled-out year. The question contains garbled formatting with incorrect quotes and delimiters.

Keep practicing — related questions