How to compare time and find the delay time?

Question

hi . i need (logintime in one table and fixed working hours is eg:9 but a employee login at 10 o clock the delay hours is 1 hour . fixed working hours is saved in one table as companytime(tablename) and employee login time is saved in another table as logintime (table) i need to compare both the table and need the delay time ) Eg: Logintime is 10 fixed time is 9 ---------- delay is 1 hour ----------------- using asp.net using c#

Senthilkumar · Answer

Hi Selvi Usually you can get the time difference by using this. SELECT DATEDIFF(hhGETDATE()-1GETDATE()) AS [Difference] I do not know about your table structure. But i assumed like this. You can change the condition according to your requirement. SELECT DATEDIFF(hhC.LogInTimeE.LoginTime) AS [Time Difference] FROM CompanyTime C INNER JOIN EmployeeLogin E ON E.ShiftType = C.ShifType WHERE E.UserID=10