//order_status = 0 未支付
select id,order_code,order_status,create_date FROM order WHERE TIMESTAMPDIFF(MINUTE,create_date,now()) > 20 AND order_status = 0;
查询20分钟未支付的订单
最新推荐文章于 2021-06-23 10:53:32 发布
//order_status = 0 未支付
select id,order_code,order_status,create_date FROM order WHERE TIMESTAMPDIFF(MINUTE,create_date,now()) > 20 AND order_status = 0;