mysql> select date_format(recDt,'%Y-%m-%d %H:%i'),avg(nowValue) from reg_conditi on group by date_format(recDt,'%Y-%m-%d %H:%i');| 2012-06-05 01:10 | 287.8076923076923 | | 2012-07-19 16:39 | -887.6 | | 2012-07-19 16:40 | 1141.1 |这样子已经可以求每分钟的平均值了。那么5分钟的平均值应该怎么搞?
SELECT SEC_TO_TIME(AVG(TIME_TO_SEC(timediff(p.CALL_END_TIME , p.CALL_START_TIME)))) num from t_phone_records p where p.STATUS='1' and p.CREATE_TIME >= '2014-10-01' and p.CREATE_TIME <= '2014-10-21' 这是我写的求平均值代码。timediff(p.CALL_END_TIME , p.CALL_START_TIME)是时间的求减。你参考一下吧
select CONCAT(date_format(MIN(ADATE), '%Y-%m-%d'),date_format(MAX(ADATE), '%Y-%m-%d')) as BDATE, AVG(NUM) as AVGNUM from TB group by datediff(ADATE,'2009-01-01')/2
on group by date_format(recDt,'%Y-%m-%d %H:%i');| 2012-06-05 01:10 | 287.8076923076923 |
| 2012-07-19 16:39 | -887.6 |
| 2012-07-19 16:40 | 1141.1 |这样子已经可以求每分钟的平均值了。那么5分钟的平均值应该怎么搞?
from t_phone_records p
where p.STATUS='1' and p.CREATE_TIME >= '2014-10-01' and p.CREATE_TIME <= '2014-10-21'
这是我写的求平均值代码。timediff(p.CALL_END_TIME , p.CALL_START_TIME)是时间的求减。你参考一下吧
select CONCAT(date_format(MIN(ADATE), '%Y-%m-%d'),date_format(MAX(ADATE), '%Y-%m-%d')) as BDATE,
AVG(NUM) as AVGNUM from TB
group by datediff(ADATE,'2009-01-01')/2