The SYSDATE function displays the current Oracle Server date as: 21-MAY-19 You wish to display the date as: MONDAY, 21 MAY, 2019 Which statement will do this?

Question

Options

• ASELECT TO_DATE(SYSDATE, `FMDAY, DD MONTH, YYYY') FROM DUAL;
• BSELECT TO_CHAR(SYSDATE, `FMDD, DAY MONTH, YYYY') FROM DUAL;
• CSELECT TO_CHAR(SYSDATE, `FMDAY, DDTH MONTH, YYYY') FROM DUAL;
• DSELECT TO_CHAR(SYSDATE, `FMDAY, DD MONTH, YYYY') FROM DUAL;

• A
  13% (3)
• B
  9% (2)
• C
  4% (1)
• D
  74% (17)

Explanation

SELECT ID, TO_CHAR(Start_Date,'fmDay Month fmDD, YYYY') AS "Start Date" FROM Type/TOCHARDatefmDayMonthfmDDYYYYEmbeddedspacescanberemovedbyplacingthefmprefi

No community discussion yet for this question.