Adding Time in HH:MM Format - Useful SQL Query

Shahriar Iqbal Chowdhury/Galib

5.00/5 (2 votes)

7 Jun 2011CPOL

11.9K

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

SQL

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

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)