Oracle中时间段查询：用日期格式查时间格式的字段

select * from T_ROLE t1
where
to_char( t1.createtime, ‘yyyy-MM-dd’) = ‘2021-03-09’;

select * from T_ROLE t1
where
to_char( t1.createtime, ‘yyyy-MM-dd’)>=‘2021-03-09’
and
to_char( t1.createtime, ‘yyyy-MM-dd’)<=‘2020-03-09’;

将创建时间字段中日期提取出来（忽略时分秒），再用前端传的日期格式数据去查。√
and trunc(t1.createtime) <![CDATA[>=]]> to_date (#{dateStart},‘yyyy-MM-dd’)
and trunc(t1.createtime) <![CDATA[<=]]> to_date (#{dateEnd},‘yyyy-MM-dd’)

select * from T_ROLE t1
where
trunc(t1.createtime)>=date’2021-03-09’ and trunc(t1.createtime)<=date’2021-03-10’;

and t1.createtime<![CDATA[>=]]> to_date(#{dateStart},‘yyyy-MM-dd’)
and t1.createtime<![CDATA[<=]]> to_date(#{dateEnd},‘yyyy-MM-dd’)