Monday, 27 August 2012

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

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

Ans:C

No comments: