Convert the date column to FLOAT, then back to DATETIME:
DECLARE @test-2 TABLE (
dtColumn datetime
)
INSERT INTO @test-2 VALUES (GETDATE() + RAND())
INSERT INTO @test-2 VALUES (GETDATE() + RAND())
INSERT INTO @test-2 VALUES (GETDATE() + RAND())
INSERT INTO @test-2 VALUES (GETDATE() + RAND())
SELECT CAST(AVG(CAST(dtColumn AS FLOAT)) AS datetime)
FROM @test-2
Hope this helps
Gianluca
-- Gianluca Sartori