[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 659
  • Last Modified:

convert hr to minutes and add mm part to converted minutes

hi
i am using oracle 8i
my table structure is
SQL> desc TESTEFFORT
 Name                                                  Null?    Type
 ----------------------------------------------------- -------- ------------
--------------------
 NO                                                             NUMBER(4)
 HOURS                                                          NUMBER(5,2)

SQL> select * from TESTEFFORT;

       NO     HOURS
--------- ---------
        1       1.5
        1       1.5
        1       .35
        1      1.05
        1       2.4
        2       1.5
        2       1.5
        2       1.5
        2       1.5
        2       1.5
i want  individual  sum of minutes  
the out put is
No          minutes
-----------------
1          380
2          550
0
schavalam
Asked:
schavalam
1 Solution
 
RimvisCommented:
Is this what you want:

select No, SUM(HOURS) * 60 AS minutes from TESTEFFORT GROUP BY No;
0
 
gajender_99Commented:
select No, SUM(HOURS) * 60 AS minutes
from TESTEFFORT
GROUP BY No
order by no asc;

0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now