---

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;

---

出自：Oracle认证

显示答案