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 dua
题目
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;
更多“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 dua”相关问题