Nov 26, 2002 #1 sahernandez Programmer Joined Oct 1, 2002 Messages 69 Location SV 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!!!
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!!!
Nov 26, 2002 1 #2 teado Programmer Joined Apr 9, 2001 Messages 21 Location US 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 Upvote 0 Downvote
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
Nov 27, 2002 #3 carp MIS Joined Sep 16, 1999 Messages 2,622 Location US select trunc(<minutes_here>/60)||':' ||to_char(mod((<minutes_here>,60),'09') from dual; Upvote 0 Downvote