SELECT * FROM 表名 WHERE (datediff(create_at, ‘2021-06-18’) = 0)
select * from 表名 where date_format(create_at,’%Y-%m-%d’) = ‘2021-06-18’
select * from 表名 where SUBSTRING(create_at,1,10) = ‘2021-06-18’
SELECT * FROM 表名 WHERE (datediff(create_at, ‘2021-06-18’) = 0)
select * from 表名 where date_format(create_at,’%Y-%m-%d’) = ‘2021-06-18’
select * from 表名 where SUBSTRING(create_at,1,10) = ‘2021-06-18’