Oracle 9iDS converting Minutes to Hour and Minutes

[rrrkrishnan]

Hi,

I am trying to convert minutes to Hour and Minutes through PL/SQL, for exmple 6 minutes should be shown as 0 Hr and 6Mins.

Any idea as how to do this?

Thanks!

 

[carp]

Something like:

CREATE OR REPLACE FUNCTION hrs_minutes(p_minutes IN NUMBER)
RETURN VARCHAR2 IS
   l_hours NUMBER;
BEGIN
   l_hours := trunc(p_minutes/60);
   RETURN to_char(l_hours)||' Hr and '||to_char(p_minutes - 60*l_hours)||'Mins';
END;
/

would give you a reusable version. Then you would get results like:

13:31:29 SQL> select hrs_minutes(6) from dual;

HRS_MINUTES(6)
---------------------------------------------------------
0 Hr and 6Mins

13:31:38 SQL> select hrs_minutes(60) from dual;

HRS_MINUTES(60)
---------------------------------------------------------
1 Hr and 0Mins

13:31:44 SQL> select hrs_minutes(650) from dual;

HRS_MINUTES(650)
---------------------------------------------------------
10 Hr and 50Mins

 

[nagornyi]

select truncminutes/60)||' Hr '|| minutes-truncminutes/60)*60)||' Mins' from dual