周日期in。 时间in in日期sql

SELECT DATE_FORMAT(log_start, '%Y-%m-%d') AS visit_date,
	   COUNT(*) AS click_count
FROM sys_log
WHERE DATE_FORMAT(log_start, '%Y-%m-%d') IN ('2024-08-12', '2024-08-13', '2024-08-14', '2024-08-15', '2024-08-16', '2024-08-17', '2024-08-18')
GROUP BY visit_date
ORDER BY visit_date;

SELECT DATE(log_start) AS visit_date,
	   COUNT(*) AS click_count
FROM sys_log
WHERE DATE(log_start) IN ('2024-08-12', '2024-08-13', '2024-08-14', '2024-08-15', '2024-08-16', '2024-08-17', '2024-08-18')
GROUP BY visit_date
ORDER BY visit_date;