模糊查询当月数据 select * from LIMS_DATA.results t where to_char(dateenter,'yyyyMMdd hh24:mi:ss') LIKE '201709%' 查询某个时间段的区间 select * from lims_data.RESULTS where DATEENTER between to_date('2017-09-13 ','yyyy