多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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
答案解析:
进入题库查看解析

微信扫一扫手机做题