//mysql 对时间操作
select
create_date
from
kf_alarm_task
where
create_date
BETWEEN
date_add(now(), interval -1 day)//前一天的时间
AND
now()
//或
select date_add(now(), interval -1 day);
//查询你某天一天之前
SELECT * FROM employee WHERE hire_date < '2000-1-1 11:11:11'
//距今大于24小时
WHERE
HOUR(timediff(now(),a.create_date))> 24
mysql 对时间操作
最新推荐文章于 2024-06-05 20:21:32 发布