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
Answer: A
谁知道C为什么不正确呢？为什么时间差是54年又2月而不是650个月？ INTERVAL YEAR TO MONTH是一种类型而不是year 到month 的转换
INTERVAL '300' MONTH 为什么转换了呢？能否告知，什么时候转换，什么时候不转换啊？ MARK 放在pl/sql development运行下不就知道了
