Monday, March 16, 2009

SUM of time

SELECT CAST(DATEADD(millisecond,
SUM(DATEDIFF(millisecond,0,CAST(totalhrs AS DATETIME))),0) AS TIME)
FROM TABLE

No comments: