27,579
社区成员
发帖
与我相关
我的任务
分享
SELECT id FROM user_remind WHERE r_time <= dateadd(mi,30,GETDATE())
SELECT id FROM user_remind
WHERE abs(datediff(n,r_time, GETDATE())) < 30
SELECT id FROM user_remind WHERE datediff(n,r_time, GETDATE()) < 30 and datediff(n,r_time, GETDATE())>=0