sql 查询当天(1)
select
*
from user t1
where
t1.time>=date(now()) and t1.time<DATE_ADD(date(now()),INTERVAL 1 DAY)
*有时候这句sql在navicat不会报错 但是放到ssm中莫名其妙报关于DATE_ADD的错
所以解决方案` *
sql 查询当天(2)
select
*
from user t1
where
date(t1.time) = curdate()
sql 查询本周
select
*
from user t1
where
YEARWEEK(date_format(t1.time,'%Y-%m-%d')) = YEARWEEK(now());
sql 查询本月记录
select
*
from user t1
where
date_format(t1.time,'%Y-%m')=date_format(now(),'%Y-%m')
***注意:“time”为对应的数据字段 为了区分写成 t1.time