Register Login

You would like to display the system date in the format "Monday, 01 June, 2001". Which SELECT statement should you use?

Updated May 18, 2018

Q. You would like to display the system date in the format "Monday, 01 June, 2001".

Which SELECT statement should you use?


A. SELECT TO_DATE (SYSDATE, 'FMDAY, DD Month, YYYY') FROM dual;
B. SELECT TO_CHAR (SYSDATE, 'FMDD, DY Month, YYYY') FROM dual;
C. SELECT TO_CHAR (SYSDATE, 'FMDay, DD Month, YYYY') FROM dual;
D. SELECT TO_CHAR (SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;
E. SELECT TO_DATE (SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;

Answer: C


×