Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can't sum Hours:Minutes:Seconds

User13484479-OracleMay 2 2011 — edited May 4 2011
Hi,

iam working on to get the sum of overtimes,late coming and early going.actually i have the 3 fields for overtime, late, early and at the end of the month i want to get the summary of these fields in format of hh:mi:ss.For ex. in overtime i may have different values for different days in format of hh:mi:ss and i want to calculate the summary of overtime for complete month. and i am using sum function but its giving me the error as invalid number.Please help me in this scenario.


Thanks
Prem
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 1 2011
Added on May 2 2011
6 comments
722 views