Which SQL statement displays the date March 19, 2001 in a format that appears as Nineteenth of March 2001 12:00:00 AM?

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;

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



Leave a Reply 3

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


Argha

Argha

Answer : SELECT TO_CHAR(TO_DATE(’19-Mar-2001′, ‘DD-Mon-YYYY’),
‘fmDdspth “of” Month YYYY fmHH:MI:SS AM’) NEW_DATE
FROM dual;

daroldrudolph

daroldrudolph

This question does not display properly. I do not see an answer b, c, d, etc.

Vincent LaBarge

Vincent LaBarge

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