Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Contributor
2134 Points
494 Posts
Jan 25, 2012 05:47 AM|LINK
hi chek the below query
SELECT DATEADD(hh,SUM(DATEPART(hh,CONVERT(DATETIME,[ColName],108))), DATEADD(n,SUM(DATEPART(n,CONVERT(DATETIME,[ColName],108))),'1900.01.01') ) FROM dbo.[TableName]
But this will not work on the value like 0 if you can update your table values into 0:0 this is working,
Sankalpa
Contributor
2134 Points
494 Posts
Re: Sum of Hours in sql server 2008,
Jan 25, 2012 05:47 AM|LINK
hi chek the below query