Which SQL statement displays the date March 19, 2001 in a format that appears as Nineteenth of
March 2001 12:00:00 AM?
SELECT
TO_CHAR(TO_DATE(’19-Mar-2001, DD-Mon-YYYY), fmDdspth
of Month YYYY fmHH:MI:SS AM) NEW_DATE
FROM dual;
SELECT
TO_CHAR(TO_DATE(19-Mar-2001, DD-Mon-YYYY), Ddspth
of Month YYYY fmHH:MI:SS AM) NEW_DATE
FROM dual;
SELECT
TO_CHAR(TO_DATE(19-Mar-2001, DD-Mon-YYYY), fmDdspth of Month YYYY
HH:MI:SS AM) NEW_DATE FROM dual;
TO_CHAR(TO_DATE(19-Mar-2001, DD-Mon-YYYY), fmDdspth of Month YYYYfmtHH:HI:SS
AM’) NEW_DATE FROM dual;
A.
SELECT
Answer : SELECT TO_CHAR(TO_DATE(’19-Mar-2001′, ‘DD-Mon-YYYY’),
‘fmDdspth “of” Month YYYY fmHH:MI:SS AM’) NEW_DATE
FROM dual;
This question does not display properly. I do not see an answer b, c, d, etc.
My Query:
select to_char(to_date(’19-MAR-2001′), ‘fmDdspth “of” Month YYYY fmHH:MI:SS PM’) from dual;
Result:
Nineteenth of March 2001 12:00:00 AM