|
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)
解析:
《SQL Language Reference》 Literal
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/17013648/viewspace-1157184/ ,如需转载,请注明出处,否则将追究法律责任。