Online Tutorials & Training Materials | STechies.com
Register Login

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

Shalesh Singh Visen || 02 Mar 2008 5:31 am || 0

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