返回数说广场
0
Oracle使用哪两个SELECT语句从系统日期中提取年份并以“2022”格式显示?
A、SELECT TO_DATE(SYSDATE,'yyyy') FROM dual;
B、SELECT TRUNC(SYSDATE, 'YEAR') FROM dual;
C、SELECT EXTRACT(YEAR from SYSDATE) from dual;
D、SELECT TO_CHAR(SYSDATE,'yyyy') FROM dual;
E、SELECT SUBSTR(SYSDATE, 0, 3) FROM dual;
2
0 212
分享
评论
热门数说


