SQLBlog Nederland Business Intelligence & Datawarehousing
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?
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:
http://codesimplified.com/2013/05/03/find-difference-between-2-dates-in-year-month-day-hour-minute-second-and-millisecond/