NUMTODSINTERVAL(3.25, 'HOUR')
SQL>
SQL> select NUMTODSINTERVAL(3.25, 'HOUR') from dual;
NUMTODSINTERVAL(3.25,'HOUR')
---------------------------------------------------------------------------
+000000000 03:15:00.000000000
SQL>
Related examples in the same category