mysql获取连续的一段月份（年月）、一段日期（年月日）、一段年月日小时

liaozk_c

于 2024-06-14 09:19:32 发布

阅读量360

点赞数 2

分类专栏：日常工作总结文章标签： mysql 数据库

本文链接：https://blog.youkuaiyun.com/liao3399084/article/details/139669540

版权

月份

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 select 4) t1,
    (select 1 union select 2 union select 3 union select 4) t2,
    (select 1 union select 2 union select 3 union select 4) t3,
    (select 1 union select 2 union select 3 union select 4) t4,
    (select @rownum:=-1) t0
    ) d1
) d2 
where m1<=CONCAT('2013-05',<

最低0.47元/天解锁文章