19. Evaluate the following query:
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
Answer: A
题目解析:INTERVAL是一个把相关字符串转换为时间长度的函数。
INTERVAL '300' MONTH 表示25年0个月(12*25=300), 即+25-00
INTERVAL '54-2' YEAR TO MONTH, 表示54年2个月,即+54-02
INTERVAL '11:12:10.1234567' HOUR TO SECOND 表示0天11小时12分钟10秒1234567毫秒,即 +00 11:12:10.123457
所以答案选A
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
Answer: A
题目解析:INTERVAL是一个把相关字符串转换为时间长度的函数。
INTERVAL '300' MONTH 表示25年0个月(12*25=300), 即+25-00
INTERVAL '54-2' YEAR TO MONTH, 表示54年2个月,即+54-02
INTERVAL '11:12:10.1234567' HOUR TO SECOND 表示0天11小时12分钟10秒1234567毫秒,即 +00 11:12:10.123457
所以答案选A