1、查询前五分钟的数据:select * from nlq_info where to_char(SYSDATE ,'yyyymmddhh24miss')-to_char(sub_time ,'yyyymmddhh24miss') < 5*60