SELECT
DATE_FORMAT( date, '%m-%d' ) time
FROM
t_time_dimension
WHERE
y = YEAR (curdate())
AND date BETWEEN DATE_FORMAT( CURDATE( ), '%Y-%m-01 00:00:00' )
AND DATE_FORMAT( DATE_SUB( CURDATE(), INTERVAL 1 DAY ), '%Y-%m-%d 23:59:59' )
GROUP BY
DATE_FORMAT(date,'%m-%d')
其中用到的表t_time_dimension 数据与结构在下方资源链接中(也可从文章最上方直接点击下载):
https://download.csdn.net/download/qq_42567801/12068874