This post describes how you can sum a column with a data type of Time in SQL Server. This column might be in a table that has employees working hours, or it might be in a box score table of your favourite sports team. You cannot simply use the SUM() function. How do you do it?
In the example below, the table is [BoxScores] and the column is [MP]. MP stands for Minutes Played.
1 | Select secTotal = SUM (DATEDIFF( SECOND , '0:00:00' , MP)) from [BoxScores] |