number in hour format

[steeve123]

I have a query that return number.

1.15
0.36
10.10


i want them in time format like
1h 9 min
0h 22 min
10h 6 min

anyone?

[tamilselvan]

For 1.15

SQL> L
1 select trunc(:b1) ||' Hr '|| round((((:b1*100) - (trunc(:b1)*100))*60/100),0) ||' Mi' "Time"
2* from dual
/

Time
----------
1 Hr 9 Mi


Tamil

[slimdave]

A little less "wordy" ...

SQL> select Trunc(1.15) ||' Hr '|| Mod(1.15,1)*60 ||' Mi' "Time"
  2  from   dual
  3  /

Time
---------
1 Hr 9 Mi

If you have to deal with negatives then:

SQL> select Trunc(-1.15) ||' Hr '|| Mod(Abs(-1.15),1)*60 ||' Mi' "Time"
  2  from   dual
  3  /

Time
----------
-1 Hr 9 Mi

(Note the ABS function)