Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"?

Q. Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"?

A. SELECT TO_CHAR(SYSDATE,'yyyy') FROM dual;

B. SELECT TO_DATE(SYSDATE,'yyyy') FROM dual;

C. SELECT DECODE(SUBSTR(SYSDATE, 8 ), 'YYYY') FROM dual;

D. SELECT DECODE(SUBSTR(SYSDATE, 8 ), 'year') FROM dual;

E. SELECT TO_CHAR(SUBSTR(SYSDATE, 8,2),'yyyy') FROM dual;


Answer: A