mysql查询近七天，半年，一年......数据

 1.查近半年

SELECT * from oms_order_item_comment 
     where comment_time between date_sub(now(),interval 6 month) and now()  -- 半年

2.查近七天

SELECT * from oms_order_item_comment 
     where comment_time between date_sub(now(),interval 1 week) and now()  -- 七天

 

3.查近一年

SELECT * from oms_order_item_comment 
     where comment_time between date_sub(now(),interval 1 year) and now()  -- 一年