81,122
社区成员




SELECT id
FROM weekorder w
WHERE w.startdate<to_date(sysdate,'yy-mm-dd') and w.enddate>to_date(sysdate,'yy-mm-dd')
select id from weekorder w where to_date(w.startdate,'yyyy-mm-dd') >= 'today' and to_date(w.enddate,'yyyy-mm-dd')<= 'today';
select id from weekorder w where w.startdate <= to_date("+today+") and enddate >= to_date("+today+");
select id from weekorder w where w.startdate <= to_date("+today+") and enddate >= to_date("+today+");