select userId
from login
where DATE_SUB(NOW(),INTERVAL 7 DAY) <= gmtCreated
sql查询7天内的数据
最新推荐文章于 2024-01-02 17:32:02 发布
select userId
from login
where DATE_SUB(NOW(),INTERVAL 7 DAY) <= gmtCreated