Mysql数据库时间查询举例详解

select now();

select subdate(now(),interval 3 hour);

select subdate(now(),interval 3 day);

select subdate(now(),interval 3 minute);

 select current_time();

select current_date();

select last_day(curdate());

select date_add(curdate(), interval - day(curdate()) + 1 day);

select date_add(curdate() - day(curdate()) + 1, interval 1 month);

select day(last_day(curdate()));

select date_sub(curdate(), interval 1 month);

select date_sub(curdate(), interval 2 month);

select datediff(curdate(), date_sub(curdate(), interval 1 month));

select * from test as 'time' where time.update_time <DATE_SUB(CURDATE(), INTERVAL 1 DAY)

select * from test as 'time' where time.update_time<DATE_SUB(CURDATE(), INTERVAL 1 WEEK)

select * from test as 'time' where time.update_time<DATE_SUB(CURDATE(), INTERVAL 1 MONTH)

select * from test as 'time' where time.update_time<DATE_SUB(CURDATE(), INTERVAL 1 YEAR)