单选题如何显示今天是星期几（周一到周日，分别用1~7表示）（）A select to_char(sysdate,'D') from dual;B select to_char(sysdate,'W') from dual;C select to_char(sysdate,'D')-1 from dual;D select to_char(sysdate-1,'D') from dual;E select to_char(sysdate-1,'W') from dual;

题目

单选题

如何显示今天是星期几（周一到周日，分别用1~7表示）（）

select to_char(sysdate,'D') from dual;

select to_char(sysdate,'W') from dual;

select to_char(sysdate,'D')-1 from dual;

select to_char(sysdate-1,'D') from dual;

select to_char(sysdate-1,'W') from dual;

参考答案和解析

正确答案： A

解析：暂无解析

更多“单选题如何显示今天是星期几（周一到周日，分别用1~7表示）（）A select to_char(sysdate,'D') from dual;B select to_char(sysdate,'W') from dual;C select to_char(sysdate,'D')-1 from dual;D select to_char(sysdate-1,'D') from dual;E select to_char(sysdate-1,'W') from dual;”相关问题

第1题

显示本月月末的日期（）A、select last_date(sysdate) from dual;B、select finally_day(sysdate) from dual;C、select last_day(sysdate) from dual;D、select tail_day(sysdate) from dual;

点击查看答案
第2题

Which three SELECT statements displays 2000 in the format “$2,000.00”?（）A、SELECT TO CNAR(2000, ‘$#,###.##’) FROM dual;B、SELECT TO CNAR(2000, ‘$0,000.00’) FROM dual;C、SELECT TO CNAR(2000, ‘$9,999.00’) FROM dual;D、SELECT TO CNAR(2000, ‘$9,999.99’) FROM dual;E、SELECT TO CNAR(2000, ‘$2,000.00’) FROM dual;F、SELECT TO CNAR(2000, ‘$N,NNN.NN’) FROM dual;

点击查看答案
第3题

Which SQL statement displays the date March 19, 2001 in a format that appears as "Nineteenth of March 2001 12:00:00 AM"?（）A、SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth "of" Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual;B、SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'Ddspth "of" Month YYYY fmHH:MI:SS AM') NEW_DATE HH:MI:SS AM') NEW _ DATE FROM dual;C、SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth "of" Month YYYY NEW _ DATE FROM dual;D、SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY), 'fmDdspth "of" Month YYYYfmtHH:HI:SS AM')NEW_DATE FROM dual;

点击查看答案
第4题

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;

点击查看答案
第5题

Which three SELECT statements display 2000 in the format "$2,000.00"? （）A、SELECT TO_CHAR(2000, '$#,###.##') FROM dual;B、SELECT TO_CHAR(2000, '$0,000.00') FROM dual;C、SELECT TO_CHAR(2000, '$9,999.00') FROM dual;D、SELECT TO_CHAR(2000, '$9,999.99') FROM dual;E、SELECT TO_CHAR(2000, '$2,000.00') FROM dual;F、SELECT TO_CHAR(2000, '$N,NNN.NN') FROM dual;

点击查看答案
第6题

如何显示今天是星期几（周一到周日，分别用1~7表示）（）A、select to_char(sysdate,'D') from dual;B、select to_char(sysdate,'W') from dual;C、select to_char(sysdate,'D')-1 from dual;D、select to_char(sysdate-1,'D') from dual;E、select to_char(sysdate-1,'W') from dual;

点击查看答案
第7题

查询出当前的数据库系统时间，精确到秒（）A、select to_date(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;B、select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;C、select date(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;D、select chr(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;

点击查看答案

单选题如何显示今天是星期几（周一到周日，分别用1~7表示）（）A select to_char(sysdate,'D') from dual;B select to_char(sysdate,'W') from dual;C select to_char(sysdate,'D')-1 from dual;D select to_char(sysdate-1,'D') from dual;E select to_char(sysdate-1,'W') from dual;

题目

参考答案和解析

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容