Sumar tiempo de fecha tipo datetime

[Libras]

Código SQL:

SELECT 
CONVERT(VARCHAR(20),datepart(hh,CAST(
AVG(
CAST( DATE AS FLOAT )
)
AS DATETIME
))) + ':' +  CONVERT(VARCHAR(20),datepart(mi,CAST(
AVG(
CAST( DATE AS FLOAT )
)
AS DATETIME
))) + ':' +CONVERT(VARCHAR(20),datepart(ss,CAST(
AVG(
CAST( DATE AS FLOAT )
)
AS DATETIME
))) AS promedio
FROM #temp
 

algo asi??? aqui dejo el link de donde saque esa idea jejejeje :)

http://www.dotnetspider.com/forum/24...rver-2000.aspx

saludos!