MySQL篇【年/月/周/日统计数据】

当字段为毫秒值时：

-- 年
select count(id) from t_demo
where YEAR(FROM_UNIXTIME(create_time/1000,'%Y-%m-%d'))=YEAR(now())

-- 月
select count(id) from t_demo
where FROM_UNIXTIME(create_time/1000,'%Y-%m') = date_format(now(),'%Y-%m')

-- 周
select count(id) from t_demo
where YEARWEEK(FROM_UNIXTIME(create_time/1000),'%Y-%m-%d') = YEARWEEK(now())

-- 日
select count(id) from t_demo
where FROM_UNIXTIME(create_time/1000,'%Y-%m-%d') = date_format(now(),'%Y-%m-%d')

当字段为dataTime时：

-- 年
select count(id) from t_demo
where YEAR(create_time)=YEAR(now())

-- 月
select count(id) from t_demo
where date_format(create_time,'%Y-%m') = date_format(now(),'%Y-%m')

-- 周
select count(id) from t_demo
where YEARWEEK(create_time,'%Y-%m-%d') = YEARWEEK(now())

-- 日
select count(id) from t_demo
where date_format(create_time,'%Y-%m-%d') = date_format(now(),'%Y-%m-%d')

ps:日期与毫秒值的转换

-- 日期转毫秒值
select UNIX_TIMESTAMP("2021-9-30");

-- 毫秒值转日期
select FROM_UNIXTIME(1493016148);