OraFAQ Forum: SQL & PL/SQL » how to calculate total duration of the course hours

Home » SQL & PL/SQL » SQL & PL/SQL » how to calculate total duration of the course hours

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to calculate total duration of the course hours [message #208063]

Fri, 08 December 2006 00:26

gi_srinivas
Messages: 19
Registered: September 2005
Location: Hyderan

Junior Member

Hi,

I need to calculate the total duration of the course hours for a particular course.

For Ex: Course_start_time = 09:30
Course_end_time = 15:00
And the Course_days = 3 days
The output should be Course_days * (Difference between the Course_end_time and Course_start_time).
like 3 * 5:30hr =16:30 hrs.

Please can anybody help me on this requirement.

Thanks and regards,
Srinivas G

Report message to a moderator

Re: how to calculate total duration of the course hours [message #208115 is a reply to message #208063]

Fri, 08 December 2006 04:24

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

total_days : = Course_days * (to_date(Course_end_time,'HH24:MI') - to_date(Course_start_time,'HH24:MI'));

total_hrs := trunc(24 * total_days);
total_mins:= trunc(3600 * total_days) - 60 * trunc(24 * total_days);

By
Vamsi

Report message to a moderator