一、oracle where条件日期筛选
时间标识
显示格式:'MM/DD/YYYY HH24:MI:SS'
两种方法:tochar和todate
二、示例
1、to_date:
select * from pt_esb_process_log
where p_date >= to_date('1/5/2023','MM/DD/YYYY')
order by p_date desc;
2、to_char:
筛选天数
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'
标签:MM,DD,YYYY,date,日期,oracle,筛选,where From: https://www.cnblogs.com/wxp100/p/17029431.html