QUESTION 19 INTERVAL的用法

最新推荐文章于 2025-11-19 16:31:32 发布

原创最新推荐文章于 2025-11-19 16:31:32 发布 · 512 阅读

0 ·

CC 4.0 BY-SA版权

OCP之路专栏收录该内容

37 篇文章

订阅专栏

本文通过一个具体的 SQL 查询示例介绍了 Oracle 数据库中 INTERVAL 数据类型的使用方法，展示了如何表示月份数、年到月的区间以及小时到秒的时间间隔。

QUESTION 19
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的用法参看Oracle官方文档：
http://docs.oracle.com/cd/B28359_01/server.111/b28286/sql_elements003.htm#SQLRF51054

SQL> SELECT INTERVAL '300' MONTH,
  2  INTERVAL '54-2' YEAR TO MONTH,
  3  INTERVAL '11:12:10.1234567' HOUR TO SECOND
  4  FROM dual;

INTERVAL'300'MONTH
---------------------------------------------------------------------------
INTERVAL'54-2'YEARTOMONTH
---------------------------------------------------------------------------
INTERVAL'11:12:10.1234567'HOURTOSECOND
---------------------------------------------------------------------------
+25-00
+54-02
+00 11:12:10.123457