使用了convert()函数
convert函数简介
SQL文:
select
convert(varchar(7),create_timestamp,120) AS 'date',
count(*) AS 'num'
from table
where status = '1' AND create_timestamp >= '2018-01-01' AND create_timestamp < '2020-12-01'
group by convert(varchar(7),create_timestamp,120);
查询结果:
简而言之就是将时间戳转成了varchar类型,并限制长度,使其显示年份及月份,然后根据月份来使用groupby分组查询