获取当前天到前七天的每天的日期
SELECT DATE_FORMAT(DATE_ADD((DATE_ADD(NOW(),INTERVAL -6 DAY)),INTERVAL +t.help_topic_id DAY),'%Y-%m-%d') AS dateValue
FROM mysql.help_topic t WHERE t.help_topic_id <![CDATA[<=]]> DATEDIFF('2021-05-10 00:00:00','2021-05-04 00:00:00')
获取当前天到前七天的每天的日期
SELECT DATE_FORMAT(DATE_ADD((DATE_ADD(NOW(),INTERVAL -6 DAY)),INTERVAL +t.help_topic_id DAY),'%Y-%m-%d') AS dateValue
FROM mysql.help_topic t WHERE t.help_topic_id <![CDATA[<=]]> DATEDIFF('2021-05-10 00:00:00','2021-05-04 00:00:00')