Which SQL statement would give the required result?

You need to display the date 11-Oct-2007 in words as ‘Eleventh of October, Two Thousand
Seven’. Which SQL statement would give the required result?

You need to display the date 11-Oct-2007 in words as ‘Eleventh of October, Two Thousand
Seven’. Which SQL statement would give the required result?

A.
SELECT TO_DATE(TO_CHAR(’11-oct-2007′,’fmDdspth ”of” Month, Year’)) FROM
DUAL;

B.
SELECT TO_CHAR(’11-oct-2007′, ‘fmDdspth “of” Month, Year’) FROM DUAL;

C.
SELECT TO_CHAR(TO_DATE(’11-oct-2007′), ‘fmDdspth of month, year’) FROM DUAL;

D.
SELECT TO_CHAR(TO_DATE(’11-oct-2007′), ‘fmDdthsp “of” Month, Year’) FROM
DUAL;



Leave a Reply 0

Your email address will not be published. Required fields are marked *