QUESTION 19 INTERVAL的用法

create_oracle

于 2014-05-10 21:50:14 发布

阅读量501

点赞数

分类专栏： OCP之路

本文链接：https://blog.youkuaiyun.com/create_oracle/article/details/25507545

版权

OCP之路专栏收录该内容

37 篇文章

订阅专栏

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

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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