Which SQL statement displays the date March 19, 2001 in a format that appears as
“Nineteenth of March 2001 12:00:00 AM”?
A.
SELECT
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”?
where are the choices ??
1* select to_char(sysdate,’fmDdspth “of” Month YYYY hh:mi:ss am’) from dual
ASH@orcl>/
TO_CHAR(SYSDATE,’FMDDSPTHOFMONTHYYYYHH:MI:SSAM’)
—————————————————————————
Eighteenth of November 2016 4:3:35 pm
SELECT TO_CHAR(TO_DATE(‘2001-03-19 00:00:00′,’YYYY-MM-DD HH24:MI:SS’),’fmDdspth “of” Month YYYY hh:mi:ss AM’) FROM dual;
TO_CHAR(TO_DATE(‘2001-03-1900:00:0
———————————-
Nineteenth of March 2001 12:0:0 AM