查询订单超过三天的数据

SELECT *  FROM `qilong_mall_order`  where DATEDIFF(NOW(),from_unixtime(addtime,'%Y-%m-%d')) < 3  limit 10

 

 

select DATEDIFF(NOW(),from_unixtime(addtime,'%Y-%m-%d'))  FROM `qilong_mall_order`