单选题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
题目
单选题
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;
相似考题
参考答案和解析
正确答案：
A
解析：
暂无解析