![](https://img-blog.csdnimg.cn/20201014180756923.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
一只小菜猫
这个作者很懒,什么都没留下…
展开
-
获取时间段内的日期数据
@[获取时间段内的所有月份] select DATE_FORMAT(m1, ‘%Y-%m’) from (select (CONCAT(‘2013-01’,’-01’) - INTERVAL DAYOFMONTH(CONCAT(‘2013-01’,’-01’))-1 DAY) + INTERVAL m MONTH as m1 from ( select @rownum:=@rownum+1 as m from (select 1 union select 2 union select 3 union se转载 2020-06-23 15:14:37 · 294 阅读 · 0 评论 -
汇总按按周,按月查看数据
计划开始时间 按周汇总 select week(planStartDate), week(planEndDate), year(planEndDate - planEndDate), count(*) count from p_workplan where year(planStartDate) = ‘2019’ group by week(planStartDate); 计划开始时间 按月汇总 select month(planStartDate), month(planEndDate), count(*原创 2020-06-18 15:30:46 · 384 阅读 · 0 评论