17,377
社区成员
发帖
与我相关
我的任务
分享
select * from your_table a where to_char(a.time_column,'yyyy-mm-dd') between '2010-01-01' and '2010-02-21'
select * from table where rq between(to_date(' 2010-2-10' ,' yyyy-mm-dd' )) and (to_date(' 2010-2-19' ,' yyyy-mm-dd' ))
select * from table where rq> =to_date(' 2010-2-10' ,' yyyy-mm-dd' ) and larq < =to_date(' 2010-2-19' ,' yyyy-mm-dd' )