SQL查询当月每天的日期

SQL查询当前月份每天的日期，如果查询对应月份，只需要对应修改NOW()函数为对应的日期即可，例如将NOW()改为1999-01-01就会列出1999年1月所有的日期

SELECT DATE_FORMAT(CONCAT(YEAR(NOW()), '-', MONTH(NOW()), '-', MonthDate.Date), '%Y-%m-%d') AS Date FROM (
  SELECT 1 AS Date UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL
  SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL 
  SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9 UNION ALL 
  SELECT 10 UNION ALL SELECT 11 UNION ALL SELECT 12 UNION ALL 
  SELECT 13 UNION ALL SELECT 14 UNION ALL SELECT 15 UNION ALL 
  SELECT 16 UNION ALL SELECT 17 UNION ALL SELECT 18 UNION ALL 
  SELECT 19 UNION ALL SELECT 20 UNION ALL SELECT 21 UNION ALL 
  SELECT 22 UNION ALL SELECT 23 UNION ALL SELECT 24 UNION ALL 
  SELECT 25 UNION ALL SELECT 26 UNION ALL SELECT 27 UNION ALL 
  SELECT 28 UNION ALL SELECT 29 UNION ALL SELECT 30 UNION ALL 
  SELECT 31) AS MonthDate 
  WHERE MonthDate.Date <= DAY (LAST_DAY(NOW()));

查询结果

2023-04-01
2023-04-02
2023-04-03
……
2023-04-29
2023-04-30