试题详情
- 单项选择题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
关注下方微信公众号,在线模考后查看
热门试题
- Which two̳
- You observe
- The order̳
- Which two code fragm
- Which statement is t
- You have
- YouaremanagingtheAPP
- Given: Under w
- To manually
- Users in
- Given: Whichcommand
- DRAGDROPClicktheTask
- Which is
- Which two options de
- Which four are corre
- A MySQL replication
- Examine this stateme
- Which two statements
- You establishe
- In the i