jsrq:结束日期
rq:开始日期
sysdate:当前时间
select * from mjxt_riqidingshirw where jsrq > trunc(sysdate) and rq <= trunc(sysdate);