给定一个年月 获取当月的所有日期

记录一下 给定一个年月 获取当月的所有日期

SELECT
    da.das AS das
  ,IFNULL( sum( t1.date ), 0 ) AS number 
FROM
    ( SELECT ( date_add( date_format(now(), '%Y-%m-%d' ), INTERVAL ( cast( help_topic_id AS signed ) - 31 ) DAY ) ) das FROM    mysql.help_topic ORDER BY help_topic_id ) da
      LEFT JOIN ( 
            SELECT COUNT(t1.habit_start_date) AS date,t1.habit_start_date AS start_date,t1.habit_end_date AS end_date FROM sch_teacher_publish_habit t1 
            LEFT JOIN sch_class t2 ON t2.deleted = 0 AND t2.user_id = '0ea0bc482d652da8718e0e682c8faf51' AND FIND_IN_SET(t1.class_id,t2.id)
            WHERE t1.deleted = 0
            ) t1 ON da.das BETWEEN date_format( t1.start_date, '%Y-%m-%d' ) AND date_format( t1.end_date, '%Y-%m-%d' ) 
WHERE
    ( date_format( da.das, '%Y-%m' ) = '2021-02' OR date_format( da.das, '%Y-%m' ) = '2021-02' ) 
GROUP BY    da.das 
ORDER BY da.das

上述示例展示的是 left join里面关联的是数据库中的表  该sql 返回值为 

List<Map<String, Object>>