oracle日期查询按日期范围select * from t_name where to_date('date','yyyy-MM-dd') between (to_date('date1','yyyy-MM-dd')) and (to_date('date2','yyyy-MM-dd'))今天select * from t_name where to_char('date','yyyy-MM-dd')=to_char(sysdate,'yyyy-MM-dd')本周select * from t