WHERE LogTime BETWEEN '2010-08-01' AND '2010-08-19'

oracle 查询 某一时间段内的数据

select * from 表名 where 时间列 between to_date ('2016-01-01','yyyy-mm-dd') and to_date ('2017-09-18','yyyy-mm-dd')