What is the correct output of the above query?

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?

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

Show Hint

Leave a Reply 1

Your email address will not be published. Required fields are marked *

helion

helion

SELECT INTERVAL ‘300’ MONTH,
INTERVAL ’54-2′ YEAR TO MONTH,
INTERVAL ’11:12:10.1234567′ HOUR TO SECOND
FROM dual;

INTER INTER INTERVAL’11
—– —– ———–
+25-00 +54-0 0 11:12:10.2123457

Reply