DATEDIFF
比较的是天数
select * from member where DATEDIFF(now(),start_time) = 0;今天
select * from member where DATEDIFF(now(),start_time) = 1; 昨天
select * from member where DATEDIFF(now(),start_time) < N; 最近几天
TIMEDIFF比较的是时间
DATEDIFF
比较的是天数
select * from member where DATEDIFF(now(),start_time) = 0;今天
select * from member where DATEDIFF(now(),start_time) = 1; 昨天
select * from member where DATEDIFF(now(),start_time) < N; 最近几天
TIMEDIFF比较的是时间