1、where时间筛选
2、date时间筛选错误
3、[Err] ORA-01861: literal does not match format string
二、拿来即用select * from t_name
where to_char(create_time,'YYYY-MM-DD') = '2021-05-20'
select * from t_name
where to_char(create_time,'YYYY-MM-DD hh24:mi:ss') >= '2021-05-20 00:00:00'