Home / T-SQL / Calculate time in hours and minutes between two dates

Calculate time in hours and minutes between two dates

 Sounds easy right? I want to calculate the difference in hours and minutes between two dates. A good readable notition for my report. I want a format like this:

00:36:53 OR 02:13:45

This can easy be done using a T-SQL Statement like this:

CONVERT(nvarchar(64), EindDatum-StartDatum, 108) AS Duration

So how does this look like in SQL Server?

T-SQL_Calculate_Difference_In_Minutes_Between_Two_Dates

Check Also

sp_send_dbmail attachment

Setup sp_send_dbmail attachment included!

I need to setup a weekly report for one of my customers. The report can be …

Geef een antwoord

Het e-mailadres wordt niet gepubliceerd. Vereiste velden zijn gemarkeerd met *