We have a need to convert a number to time.For instance, the value returned by SQL is: 5.25The time equivalent of this number is 05:15 and 5.75, which should be 05:45.
To accomplish this, we can use the NUMTODSINTERVAL function.
SQL> select to_char(time'0:0:0'+numtodsinterval(&time,'hour'),'hh24:mi:ss') tm from dual;