Which SQL statement displays the date March 19, 2001 in a format that appears asNineteenth of March 2001 12:00:00 AM?
Posted: Wed Jun 07, 2023 6:12 am
Which SQL statement displays the date March 19, 2001 in a format that appears asNineteenth of March 2001 12:00:00 AM?
A. SELECT TO_CHAR(TO_DATE('19-Mar-2001, DD-Mon-YYYY), fmDdspth of Month YYYY fmHH:MI:SS AM) NEW_DATE FROM dual;
B. SELECT TO_CHAR(TO_DATE(19-Mar-2001, DD-Mon-YYYY), Ddspth of Month YYYY fmHH:MI:SS AM) NEW_DATE FROM dual;
C. SELECT TO_CHAR(TO_DATE(19-Mar-2001, DD-Mon-YYYY), fmDdspth of Month YYYY HH:MI:SS AM) NEW_DATE FROM dual;
D. SELECT TO_CHAR(TO_DATE(19-Mar-2001, DD-Mon-YYYY), fmDdspth of Month YYYYfmtHH:HI:SS AM') NEW_DATE FROM dual;
A. SELECT TO_CHAR(TO_DATE('19-Mar-2001, DD-Mon-YYYY), fmDdspth of Month YYYY fmHH:MI:SS AM) NEW_DATE FROM dual;
B. SELECT TO_CHAR(TO_DATE(19-Mar-2001, DD-Mon-YYYY), Ddspth of Month YYYY fmHH:MI:SS AM) NEW_DATE FROM dual;
C. SELECT TO_CHAR(TO_DATE(19-Mar-2001, DD-Mon-YYYY), fmDdspth of Month YYYY HH:MI:SS AM) NEW_DATE FROM dual;
D. SELECT TO_CHAR(TO_DATE(19-Mar-2001, DD-Mon-YYYY), fmDdspth of Month YYYYfmtHH:HI:SS AM') NEW_DATE FROM dual;