可学答题网 > 问答 > 1Z0-007题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

Which SELECT statement should you use


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
参考答案
参考解析:
分类:1Z0-007题库