extrobe
9/13/2017 - 2:47 PM

Average of Dates / Times

-- Average Times
CAST(AVG(CAST(ResponseTime AS FLOAT)) AS DATETIME)  as AvgResponseTime

-- Average Dates
SELECT CAST(AVG(CAST(datefield AS INT)) AS DATETIME) FROM dates;