I have a very simple solution. If you have a field in database in int format and you want to know how many seconds it’s, the query is:
SELECT CONVERT(char(5), DATEADD(second, AVG(Avg_time), ‘20150101’), 108) as myAverage
FROM T_GoogleAnalytics_data
HAVING (AVG(Avg_time) IS NOT NULL)
You must log in to post a comment.