mysql 时间函数

 

 

select date_add(NOW(), interval 7 day ) as tms;

select date_sub(NOW(), interval 7 day ) as tms;

 

select datediff(NOW() ,"2022-01-30") as tms;