mysql 时间比较

SELECT DATE_FORMAT(create_time,'%Y%m%d') AS 时间,COUNT(id)AS 数量 FROM `table` WHERE  DATEDIFF(create_time,'2021-09-01')>=0 
GROUP BY DATE_FORMAT(create_time,'%Y%m%d');

SELECT FROM_UNIXTIME(create_time,'%Y%m%d') AS DATE,COUNT(id)AS 数量 FROM `table` WHERE  DATEDIFF(FROM_UNIXTIME(create_time,'%Y-%m-%d'),'2021-09-01')>=0