发布网友 发布时间:2022-04-08 18:19
共2个回答
热心网友 时间:2022-04-08 19:48
select trunc(sysdate,'yyyy') - to_char(trunc(sysdate,'yyyy'),'d')-5 + :week* 7 startweek,trunc(sysdate,'yyyy') - to_char(trunc(sysdate,'yyyy'),'d')+1 +:week* 7 as endweek from al;热心网友 时间:2022-04-08 21:06
select (trunc( sysdate,'ww')-trunc( sysdate,'yyyy'))/7+1 as wNum from al --当前第多少周