Which SQL statement would give the required result?

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?

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(TO_DATE(‘ll-oct-2007’), ‘miDdthsp “of* Month. Year’) FROM DUAL;

B.
SELECT TO_DATE(TO_CHAR(‘ll-oct-20077fiiiDdspth “of” Month. Year’)) FROM DUAL:

C.
SELECT TO_CHAR(TO_DATE(‘ll-oct-2007’X ‘miDdspth of month, year’) FROM DUAL;

D.
SELECT TO_CHAR(‘ll-oct-2007’. ‘miDdspth “of Month. Year’) FROM DUAL:

Show Hint

Leave a Reply 1

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

helion

helion

ALTER SESSION SET nls_date_format = ‘dd-mm-rr’;

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

TO_CHAR(TO_DATE(’11-OCT-2007′),’DDTHSP”OF”MONTH,YEAR’)
———————————————————————–
Eleventh of October , Two Thousand Seven

Reply