mysql中统计每小时，每天，每月，每年注册人数

解析时间戳 

SELECT CURRENT_DATE,CURRENT_TIME,CURRENT_TIMESTAMP,YEAR(CURRENT_TIMESTAMP),MONTH(CURRENT_TIMESTAMP),DAY(CURRENT_TIMESTAMP),HOUR(CURRENT_TIMESTAMP),MINUTE(CURRENT_TIMESTAMP),SECOND(CURRENT_TIMESTAMP)

每年注册人数

SELECT YEAR(reg_time) as _year,COUNT(*) as total FROM dt_users GROUP BY YEAR(reg_time)

 指定年份的每月注册用户数量

SELECT MONTH(reg_time) as _month,COUNT(*) as total FROM dt_users WHERE YEAR(reg_time) =2022 GROUP BY MONTH(reg_time)

指定年份，指定月份的每天注册用户数量 

方式一：【强烈推荐】 

此方式很推荐，因为可以随意查询指定年份指定月份的数据 

select DAY(reg_time),count(*) from dt_users where YEAR(reg_time)=2023 and MONTH(reg_time)=2 group by DAY(reg_time)

方式二：

用 between and

select DAY(reg_time),count(*) from dt_users where reg_time between '2023-2-1' and '2023-3-1' group by DAY(reg_time)

 当天各个小时注册用户数量

方式一：【推荐】 

select HOUR(reg_time) as _hour,count(*) as total from dt_users where reg_time > CURRENT_DATE group by HOUR(reg_time)

 方式二：

select HOUR(reg_time),count(*) from dt_users where reg_time>'2023-03-10 00:00:00' group by HOUR(reg_time)

 

select reg_time,HOUR(reg_time) from dt_users where reg_time>'2023-03-10 00:00:00'