Mysql5.7 时间查询

 查询 expiration_time >= 2024-01-30 的结果

SELECT *
FROM your_table_name
WHERE DATE_FORMAT(expiration_time, '%Y-%m-%d') >= DATE_FORMAT('{$date_time}', '%Y-%m-%d');