sql server getdate subtract hours code example
Example: SQL server select to get sum of hours
SELECT DATEADD(ms, SUM(DATEDIFF(ms, '00:00:00.000', YourFieldName)), '00:00:00.000') as time FROM YourTableName
SELECT DATEADD(ms, SUM(DATEDIFF(ms, '00:00:00.000', YourFieldName)), '00:00:00.000') as time FROM YourTableName