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)

By Enrico

My greatest passion is technology. I am interested in multiple fields and I have a lot of experience in software design and development. I started professional development when I was 6 years. Today I am a strong full-stack .NET developer (C#, Xamarin, Azure)

This site uses Akismet to reduce spam. Learn how your comment data is processed.