Adding Time in HH:MM Format - Useful SQL Query [Tip/Trick]
Posted: 7 Jun 2011
Updated: 7 Jun 2011
Rating: 5.00/5
Votes: 2
Popularity: 1.51
Licence: The Code Project Open License (CPOL)
Bookmarked: 0
Downloaded: 0
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