mysql 根据时间段取值
-- 今天 select fullName,addedTime from t_user where to_days(addedTime) <= to_days(now()); -- 昨天 select fullName,addedTime from t_user where to_days(NOW()) - TO_DAYS(addedTime) <= 1; -- 近7天 sel...
转载
2018-07-04 14:02:30 ·
636 阅读 ·
0 评论