88.You need to calculate the number of days from 1st January 2007 till date.

最新推荐文章于 2022-09-20 20:59:37 发布

今年我18

最新推荐文章于 2022-09-20 20:59:37 发布

阅读量1.5k

点赞数

分类专栏： 1z0-051 文章标签： 1z0-051

本文链接：https://blog.csdn.net/dwj19830118/article/details/50789593

版权

1z0-051 专栏收录该内容

175 篇文章 1 订阅

订阅专栏

88.You need to calculate the number of days from 1st January 2007 till date.
Dates are stored in the default format of dd-mon-rr.

Which SQL statements would give the required output? (Choose two .)
A.SELECT SYSDATE - '01-JAN-2007' FROM DUAL;
B.SELECT SYSDATE - TO_DATE('01/JANUARY/2007') FROM DUAL;
C.SELECT SYSDATE - TO_DATE('01-JANUARY-2007') FROM DUAL;
D.SELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY') - '01-JAN-2007' FROM DUAL;
E.SELECT TO_DATE(SYSDATE, 'DD/MONTH/YYYY') - '01/JANUARY/2007' FROM DUAL;
答案：BC
解析：只有日期才能相减，排除ADE，bc可以参考 85题，他们的分隔符好一个是/一个是-，其实是没啥区别的
SQL> SELECT SYSDATE - TO_DATE('01-JANUARY-2007') FROM DUAL;

SYSDATE-TO_DATE('01-JANUARY-2007')
----------------------------------
3349.68645

SQL> SQL> SELECT SYSDATE - TO_DATE('01.JANUARY.2007') FROM DUAL;

SYSDATE-TO_DATE('01.JANUARY.2007')
----------------------------------
3349.68657

SQL> SELECT SYSDATE - TO_DATE('01_JANUARY_2007') FROM DUAL;

SYSDATE-TO_DATE('01_JANUARY_2007')
----------------------------------
3349.68669

SQL> SELECT SYSDATE - TO_DATE('01,JANUARY,2007') FROM DUAL;

SYSDATE-TO_DATE('01,JANUARY,2007')
----------------------------------
3349.68686
SQL> SELECT SYSDATE - TO_DATE('01/JANUARY/2007') FROM DUAL;

SYSDATE-TO_DATE('01/JANUARY/2007')
----------------------------------
3349.68833

SQL> SELECT SYSDATE - TO_DATE('01\JANUARY\2007') FROM DUAL;

SYSDATE-TO_DATE('01\JANUARY\2007')
----------------------------------
3349.68841

SQL> SELECT SYSDATE - TO_DATE('01|JANUARY|2007') FROM DUAL;

SYSDATE-TO_DATE('01|JANUARY|2007')
----------------------------------
3349.6886