select * from 表名 where 时间字段 between to_date(‘2020-12-16 00:00:00’, ‘yyyy-mm-dd hh24:mi:ss’) and to_date(‘2020-12-16 12:00:00’, ‘yyyy-mm-dd hh24:mi:ss’)
select * from 表名 where to_char(时间字段,‘yyyy-MM-dd HH24:mm:ss’) between ‘2020-12-16 00:00:00’ and ‘2020-12-16 12:00:00’