56,679
社区成员
发帖
与我相关
我的任务
分享
select * from tig_users
where last_login between curdate()-INTERVAL 1 day and CURDATE()
select * from tig_users
where date(last_login)=curdate()-INTERVAL 1 day
select * from tt
where f1 >= DATE_SUB(curdate(), INTERVAL 1 DAY)
and f1 < current_date();