Which SQL statement displays the date March 19, 2001 in a format that appears as “Nineteenth of March 2001 12:00:00 AM”?
A. SELECTTO_CHAR(TO_DATE(’19-Mar-2001′, ‘DD-Mon-YYYY’), ‘fmDdspth”of” Month YYYY fmHH:MI:SS AM’) NEW_DATEFROM dual;
B. SELECTTO_CHAR(TO_DATE(’19-Mar-2001′, ‘DD-Mon-YYYY’), ‘Ddspth”of” Month YYYY fmHH:MI:SS AM’) NEW_DATEFROM dual;
C. SELECTTO_CHAR(TO_DATE(’19-Mar-2001′, ‘DD-Mon-YYYY’), ‘fmDdspth “of” Month YYYYHH:MI:SS AM’) NEW_DATE FROM dual;
D. SELECTTO_CHAR(TO_DATE(’19-Mar-2001′, ‘DD-Mon-YYYY), ‘fmDdspth “of” Month YYYYfmtHH:HI:SS AM’) NEW_DATE FROM dual;
|
Download Printable PDF. VALID exam to help you PASS. |
 |