Advertisement
Advertisement

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)

Advertisement
Advertisement

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)

Leave a Reply

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

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.