TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Hussain Ahmed
NA
61
1.4k
Calculate total time in oracle sql
Jan 2 2017 6:33 AM
Select Op.Operator_Name,Op.Emp_Code,
(Cast (Oplogin1.Signout_Time As Timestamp) - Cast (Oplogin1.Signin_Time As Timestamp)) As Licensed_Time,
(Cast (Oplogin2.Signout_Time As Timestamp) - Cast (Oplogin2.Signin_Time As Timestamp)) As Trainee_Time,
(Cast (Oplogin3.Signout_Time As Timestamp) - Cast (Oplogin3.Signin_Time As Timestamp)) As Superviser_Time
From Tblsapt_Operator Op
Left Join Tblsapt_Loginst_Operator1 Oplogin1 On (Op.Emp_Code = Oplogin1.Operator)
Left Join Tblsapt_Loginst_Operator2 Oplogin2 On (Op.Emp_Code = Oplogin2.Operator)
Left Join Tblsapt_Loginst_Operator3 Oplogin3 On (Op.Emp_Code = Oplogin3.Operator)
i am using the above query .using sql oracle i want to total "TRAINEE_TIME" with respect to EMP_CODE as mentioned in attached image. please help.
Reply
Answers (
2
)
Data members and Member Functions
How to populate dropdownlist in grid in MVC