SQL DateTime Summation

Question

I have like this data:

I want to sum TIME_Column hours in specific year.

Summation of output for 2019 should be 12.5

Summation of output for 2020 should be 14.0

Answer 1

You can try to use DATEPART to get hours & minute numbers from your TIME_Column, the minute numbers might need division by 60, then do SUM aggregate.

SELECT DATEPART(YEAR, DATE_Column),SUM(DATEPART(HOUR, TIME_Column) + DATEPART(MINUTE, TIME_Column)/60.0)
FROM T
GROUP BY DATEPART(YEAR, DATE_Column)

sqlfiddle

NOTE

I would combine TIME_Column & DATE_Column to one column, there might no reason need to spite datetime to two column I think.