mysql 常用函数

MYSQL 5

select * from member where DATEDIFF(now(),mem_reg_time) = 0;   // 查询今天注册的会员
select * from member where DATEDIFF(now(),mem_reg_time) = 1; // 查询昨天注册的会员
select * from member where DATEDIFF(now(),mem_reg_time) < N;   // 查询最近N天注册的会员

在时间范围内
select * from test where date_format(create_time,'%Y-%m-%d') between '2018-07-30' and '2018-07-31';

mysql时间函数
https://blog.csdn.net/qinshijangshan/article/details/72874667

是否是一天
TO_DAYS(NOW())= TO_DAYS(service_start)			
比较时间大小
SUBTIME(#{startDate,jdbcType=VARCHAR}, '15:00:00') >= 0