How to addd a two times in asp.net using c sharp

Hi Mohanraj

Here is the Query

SELECT EmpId, [Date], RIGHT(REPLICATE('0', 2) + cast(A.H as varchar),2) + ':' + RIGHT(REPLICATE('0', 2) + cast(A.M as varchar),2) + ':' + RIGHT(REPLICATE('0', 2) + cast(A.S as varchar),2) as [Time]
from (
SELECT EmpId, [Date], SUM(datepart(HOUR,[Time])) AS H, SUM(datepart(MINUTE,[Time])) as M, SUM(datepart(SECOND,[Time])) as S
FROM EmpTime
GROUP BY EmpId, [Date]
) as A



Hope this helps.