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?
A.
SELECT TO_CHAR(‘ll-oct-2007’. ‘miDdspth “of Month. Year’)
FROM DUAL:
B.
SELECT TO_CHAR(TO_DATE(‘ll-oct-2007’X ‘miDdspth of month, year’)
FROM DUAL;
C.
SELECT TO_CHAR(TO_DATE(‘ll-oct-2007’), ‘miDdthsp “of* Month. Year’)
FROM DUAL;
D.
SELECT TO_DATE(TO_CHAR(‘ll-oct-20077fiiiDdspth “of” Month. Year’))
FROM DUAL:
A is incorrect.
Correct C.
SELECT TO_CHAR(TO_DATE(’11-OCT-2007′), ‘fmDdspth “of” Month, Year’) FROM DUAL;
http://www.aiotestking.com/oracle/which-sql-statement-would-give-the-required-result-11/
C – tested