查询当天时间最小值
SELECT DATE_FORMAT(CURDATE(),'%Y-%m-%d %H:%i:%s');
查询当天时间最大值
SELECT DATE_SUB(DATE_ADD(CURDATE(), INTERVAL 1 DAY),INTERVAL 1 SECOND)
统计当天每小时发生的次数
SELECT HOUR ( time ) AS time, count( * ) AS total
FROM 表名 AS sr
WHERE time
BETWEEN DATE_FORMAT( CURDATE( ), '%Y-%m-%d %H:%i:%s' )
AND
DATE_SUB( DATE_ADD( CURDATE( ), INTERVAL 1 DAY ), INTERVAL 1 SECOND )
GROUP BY HOUR ( time )
ORDER BY HOUR ( time )
统计本周内周一到周日的次数
SELECT
DAYOFWEEK(DATE_ADD(time,INTERVAL -1 DAY))
, count(1) as count
FROM 表名
WHERE
YEARWEEK( date_format( DATE_ADD(time,INTERVAL -1 DAY) , '%Y-%m-%d' ) ) = YEARWEEK( now( ) )
GROUP BY
TO_DAYS(time)