Which SELECT statement should you use to extract t...
单选题

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

发布日期:2020-04-10

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;

热门试题

热门资讯

    暂无相关推荐~

分享给好友

分享到朋友圈

取消

使用浏览器的分享功能,把这篇文章分享出去

确定