试题详情
单项选择题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;

  • 关注下方微信公众号，在线模考后查看

热门试题