Home‎ > ‎blog‎ > ‎

SQL TimeDiff Average

posted 7 Sep 2010, 12:59 by Andreas Jostel
select
col1,
avg(timestampdiff(SECOND, startTimestamp, endTimestamp)) as avgdiff
from
table
group by col1
Comments