运算符=
select * from TB_BLOCK_INFO t
where t.create_date = to_date('2022.10.10 0:02:02','yyyy.mm.dd hh24:mi:ss');
between(sysdate代表系统当前时间)
select * from TB_BLOCK_INFO t
where t.create_date between
to_date('2022.10.10 0:02:02','yyyy.mm.dd hh24:mi:ss')
and to_date(sysdate);