select INTERVAL '2' year as "year",
INTERVAL '3' month as "month",
INTERVAL '3' day as "day",
INTERVAL '3' hour as "hour",
INTERVAL '3' minute as "minute",
INTERVAL '3.15' second as "second",
INTERVAL '2 12:30:59' DAY to second as "DAY to second",
INTERVAL '13-3' year to month as "Year to month"
from dual;
year | 2 |
month | -3 |
day | +03 00:00:00 |
hour | +00 03:00:00 |
minute | +00 00:03:00 |
second | +00 00:00:03.150000 |
DAY to second | +02 12:30:59.000000 |
Year to month | 10 |
SQL> SELECT NUMTODSINTERVAL(9.5 * 60, 'SECOND') FROM dual;
NUMTODSINTERVAL(9.5*60,'SECOND
-------------------------------------------------------------------------------
+000000000 00:09:30.000000000