最简单就是 where rq between date '2005-09-10' and date '2005-10-15'也可以 where rq between to_date('2005-09-10','yyyy-mm-dd') and to_date('2005-10-15','yyyy-mm-dd')
SELECT * FROM TB WHERE DATE_FILED BETWEEN '2005-09-10' AND '2005-10-15';
select * from table where to_char(date,'yyyyMMdd') between '20050910' and '20051015';
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货