mysql 统计某时间段内每天的总数
2018-01-19 本文已影响0人
任人渐疏_Must
SELECT FROM_UNIXTIME(addtime,'%Y-%m-%d'),count(*) as count FROM agent
WHERE addtime BETWEEN 1515893709 AND 1516008205
GROUP BY FROM_UNIXTIME(addtime,'%Y%m%d')
ORDER BY addtime
SELECT FROM_UNIXTIME(addtime,'%Y-%m-%d'),count(*) as count FROM agent
WHERE addtime BETWEEN UNIX_TIMESTAMP('2018-1-1 00:00:00') AND UNIX_TIMESTAMP('2018-1-31 23:59:59')
GROUP BY FROM_UNIXTIME(addtime,'%Y%m%d')
ORDER BY addtime
