MYSQL获取某月天数

最新推荐文章于 2022-09-08 22:40:40 发布

一只小鸟儿

最新推荐文章于 2022-09-08 22:40:40 发布

阅读量2.9k

点赞数 1

CC 4.0 BY-SA版权

分类专栏： MySQl 文章标签： mysql 数据库 database

本文链接：https://blog.youkuaiyun.com/Theshy08/article/details/122377738

MySQl 专栏收录该内容

10 篇文章

订阅专栏

本文通过SQL查询，汇总了2020年每个月最后一天的日期，计算了对应的每一天作为活跃天数，便于分析全年数据分布情况。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

select day(  last_day( concat(( 	SELECT CONCAT('2020','01') AS date  ),'01')   ))  AS cm_day_cnt UNION all
select day(  last_day( concat(( 	SELECT CONCAT('2020','02') AS date  ),'02')   ))  AS cm_day_cnt UNION all
select day(  last_day( concat(( 	SELECT CONCAT('2020','03') AS date  ),'03')   ))  AS cm_day_cnt UNION all
select day(  last_day( concat(( 	SELECT CONCAT('2020','04') AS date  ),'04')   ))  AS cm_day_cnt UNION all
select day(  last_day( concat(( 	SELECT CONCAT('2020','05') AS date  ),'05')   ))  AS cm_day_cnt UNION all
select day(  last_day( concat(( 	SELECT CONCAT('2020','06') AS date  ),'06')   ))  AS cm_day_cnt UNION all
select day(  last_day( concat(( 	SELECT CONCAT('2020','07') AS date  ),'07')   ))  AS cm_day_cnt UNION all
select day(  last_day( concat(( 	SELECT CONCAT('2020','08') AS date  ),'08')   ))  AS cm_day_cnt UNION all
select day(  last_day( concat(( 	SELECT CONCAT('2020','09') AS date  ),'09')   ))  AS cm_day_cnt UNION all
select day(  last_day( concat(( 	SELECT CONCAT('2020','10') AS date  ),'10')   ))  AS cm_day_cnt UNION all
select day(  last_day( concat(( 	SELECT CONCAT('2020','11') AS date  ),'11')   ))  AS cm_day_cnt UNION all
select day(  last_day( concat(( 	SELECT CONCAT('2020','12') AS date  ),'12')   ))  AS cm_day_cnt