Adding Time in HH:MM Format - Useful SQL Query

Shahriar Iqbal Chowdhury/Galib

5.00/5 (2 votes)

Jun 7, 2011

CPOL

11881

Hi,Here is an alternative for your solutionSELECT CAST(DATEADD(MILLISECOND,SUM(DATEDIFF(MILLISECOND,0,CAST(TMP.TotalTime as DATETIME))),0) as TIME)FROM( SELECT CAST(timeduration AS TIME) TotalTime FROM mytable) TMP

Hi, Here is an alternative for your solution

SELECT CAST(DATEADD(MILLISECOND,
SUM(DATEDIFF(MILLISECOND,0,
CAST(TMP.TotalTime as DATETIME))),0) as TIME)
FROM
(
    SELECT CAST(timeduration AS TIME) TotalTime FROM mytable
) TMP