select * from t_register r where r.reg_date <= to_date(trunc(sysdate, 'mi') - 10 / (24 * 60)); 转载于:https://www.cnblogs.com/qiushuiblog/p/7160676.html