Math Help with minutes to HH24:MI 1

[sahernandez]

Hi, I just want to know the optime way to do this:

I have
Minutes ----- > HH24:Mi
25 00:25
5 00:05
125 02:05

I just want to transform the minutes to a easy way to read.

HELP ME!!!

 

[teado]

I am sure there's a much prettier way of doing it, but I just tried:

select to_char(to_date(to_char(180*60),'SSSSS'),'HH24:MI') from dual;

= 03:00

 

[carp]

select trunc(<minutes_here>/60)||':'
||to_char(mod((<minutes_here>,60),'09') from dual;