Count time difference in hh:mm:ss between two Date in SQL Server

Question

I have Database with name parkingwith table A contain fieldid identityvehiclestartendI want add sum start and end with format like 2 hour 20 minutewith store procedure sql server  thanks any help

dharmendr · Accepted Answer

Hi Ruben12345Refer the below sample queryDECLARE TABLEA AS TABLE ID INT IDENTITY11Vehicle VARCHAR50Start DATETIME End DATETIMEINSERT INTO TABLEA VehicleStartEnd VALUES39Maruti SX4393920170425 112900393920170425 15003639INSERT INTO TABLEA VehicleStartEnd VALUES39Honda City393920170426 122936393920170426 15003639SELECT IDVehicleCONVERTVARCHAR5DATEDIFFS Start End360039 hours 39CONVERTVARCHAR5DATEDIFFS Start End36006039 minutes 39CONVERTVARCHAR5DATEDIFFS Start End6039 seconds39 AS TIME FROM TABLEAOutput IDVehicleTIME1Maruti SX43 hours 31 minutes 36 seconds2Honda City2 hours 31 minutes 0 seconds

Count time difference in hh:mm:ss between two Date in SQL Server

Company

Explore

Follow us

Contact Us