- 69,(31-1)choose the best answer:
- 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 , +00-650, +00 11:12:10.123457
- B) +25-00 , +54-02, +00 11:12:10.123457
- C) +00-300, +00-650, +00 11:12:10.123457
- D) +00-300, +54-02, +00 11:12:10.123457
- Answer:B
(解析:
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 秒
)
来源: http://www.bubuko.com/infodetail-2980157.html