汇总按按周,按月查看数据

计划开始时间 按周汇总

select week(planStartDate), week(planEndDate), count(*) count
from p_workplan
where year(planStartDate) = ‘2019’
group by week(planStartDate);

计划开始时间 按月汇总

select month(planStartDate), month(planEndDate), count(*) count
from p_workplan
where year(planStartDate) = ‘2020’
group by week(planStartDate);

获取日期区间相隔年数

SELECT TIMESTAMPDIFF(YEAR,planStartDate,planEndDate) year from p_workplan;