一、原题
Evaluate the following query:
SELECT INTERVAL '300' MONTH,
INTERVAL '54-2' YEAR TO MONTH,
INTERVAL '11:12:10.1234567' HOUR TO SECOND
FROM dual;
What is the correct output of the above query?
A. +25-00 , +54-02, +00 11:12.10.123457
B. +00-300, +54-02, +00 11:12:10.123457
C. +25-00 , +00-650, +00 11:12:10.123457
D. +00-300 , +00-650, +00 11:12:10.123457
答案: A
二、题目翻译
评估下面的查询语句:
上面的查询语句正确的输出结果是什么?
三、题目解析
INTERVAL '300' MONTH:300个月为+25-00(25年,即25*12+0)
INTERVAL '54-2' YEAR TO MONTH:+54-02,表示54年零2个月
INTERVAL '11:12:10.1234567' HOUR TO SECOND: +00 11:12:10.123457(+00表示0天),表示11个小时,12分,10.123457秒
INTERVAL的详细用法见:
http://blog.csdn.net/holly2008/article/details/23629351
Evaluate the following query:
SELECT INTERVAL '300' MONTH,
INTERVAL '54-2' YEAR TO MONTH,
INTERVAL '11:12:10.1234567' HOUR TO SECOND
FROM dual;
What is the correct output of the above query?
A. +25-00 , +54-02, +00 11:12.10.123457
B. +00-300, +54-02, +00 11:12:10.123457
C. +25-00 , +00-650, +00 11:12:10.123457
D. +00-300 , +00-650, +00 11:12:10.123457
答案: A
二、题目翻译
评估下面的查询语句:
上面的查询语句正确的输出结果是什么?
三、题目解析
INTERVAL '300' MONTH:300个月为+25-00(25年,即25*12+0)
INTERVAL '54-2' YEAR TO MONTH:+54-02,表示54年零2个月
INTERVAL '11:12:10.1234567' HOUR TO SECOND: +00 11:12:10.123457(+00表示0天),表示11个小时,12分,10.123457秒
INTERVAL的详细用法见:
http://blog.csdn.net/holly2008/article/details/23629351