采用between
select * from table1 where cast(TO_DATE(start_time,'yyyyMMddHHmmss') as date) between cast(TO_DATE('20200514000000','yyyyMMddHHmmss') as date) and cast(TO_DATE('20200515000000','yyyyMMddHHmmss') as date);
采用比较运算符>和<
select start_time from table1 where cast(TO_DATE(start_time,'yyyyMMddHHmmss') as date) > cast(TO_DATE('20200514000000','yyyyMMddHHmmss') as date) and cast(TO_DATE(start_time,'yyyyMMddHHmmss') as date) <cast(TO_DATE('20200515000000','yyyyMMddHHmmss') as date);
between运行结果
比较运算符运行结果