--超过12小时的订单 select * from order_info o1 where to_date(o1.commit_time, 'YYYY-MM-DD HH24:MI:SS') <= sysdate - 1 / 2;
--超过12小时的订单 select * from order_info o1 where to_date(o1.commit_time, 'YYYY-MM-DD HH24:MI:SS') <= sysdate - 1 / 2;
转载于:https://www.cnblogs.com/wangchuanfu/p/10931853.html