USER | Log_Date | Log_In_Time | Log_Out_Time | -------------------------------------------------------------------------------- xxx | 2013-10-02 23:00:31.623|2013-10-02 23:07:31.623|2013-10-03 01:08:31.623|
|TOTAL| ------- |2.08 |
SELECT DATEDIFF(HOUR,Log_In_Time,Log_OUT_Time)
SELECT DATEDIFF(mi,Log_In_Time,Log_OUT_Time)/60;
SELECT CAST(DATEDIFF(mi, Log_In_time, Log_Out_Time) AS FLOAT)/60 AS Total FROM MYTable
Declare @Time int,@LoginTime datetime = '2013-10-02 23:00:00',@LogoutTime datetime = '2013-10-03 01:08:00' Set @Time = DATEDIFF(Minute,@LoginTime,@LogoutTime) SELECT CAST( @Time/60 AS VARCHAR(5))+ ' Hrs' + ':'+ RIGHT('0' + CAST( @Time%60 AS VARCHAR(2)), 2)+' Min' AS 'WorkingTime'
select DATEDIFF(hh,getdate(),getdate()+1) --For hours select DATEDIFF(mi,getdate(),getdate()+1) --for mins
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)