how i can add two diffrent time
-
Hi, I am using sql server 7.0 in that i am having a table of 3 feild i.e. empName, Logindate, HoursWorked select * from tablename Result: empName LoginDate HoursWorked ------- ------------ ------------ Amit 06/03/04 13:44:45 Amit 06/04/04 14:44:45 now i want the sum of the field "HoursWorked" Can any body help?
-
Hi, I am using sql server 7.0 in that i am having a table of 3 feild i.e. empName, Logindate, HoursWorked select * from tablename Result: empName LoginDate HoursWorked ------- ------------ ------------ Amit 06/03/04 13:44:45 Amit 06/04/04 14:44:45 now i want the sum of the field "HoursWorked" Can any body help?
Your results are a little confusing. What is the data type of HoursWorked?
-
Your results are a little confusing. What is the data type of HoursWorked?
Actually im taking 'LoginTime' and 'LogoutTime' Datatype 'DateTime' from "login" table and subtraction of this two field is strored in field 'TimeDiffrence' datatype varchar Query i m using is "convert(varchar(8),(logoutTime-loginTime),14)Timediffrence" now i want the sum of the field "Timediffrence"