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!

converting minutes to hours and minutes

760814Apr 5 2010 — edited Apr 11 2010
hi all,

i want to do two things

1. i want to convert minutes to hours and minutes that is
if there are 350 minutes it should be 5.50

2. i have two column time allowed hrs and time allowed mins now i want to join this two in
this way
for example time allowed hrs is 5 and time allowed mins is 40 then i should be join as 5.40


Regards
Abhi.
This post has been answered by Frank Kulash on Apr 9 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 9 2010
Added on Apr 5 2010
17 comments
31,198 views