就是计算从年份0开始的天数
//查询昨天的数据
select * from order where to_days(now())-to_days(create_time)<1
//同理前天的数据
select * from order where to_days(now())-to_days(create_time)<2 and to_days(now())-to_days(create_time)>1
mysql的TO_DAYS函数
最新推荐文章于 2024-02-24 12:26:08 发布