Oracle获取当前自然周，当前周的起止日期SELECTto_char(sysdate,"iw")fromdual;从dual中选择to_char(sysdate,"yyyy")进入v_sbzq_nf；--当前年份SELECTto_char(TRUNC(TO_DATE(to_char(sysdate,"yyyy-MM-dd"),"yyyy-MM-dd"),"IW"),"yyyy-MM-dd")FROMDUAL;--本周开始时间（本周周一日期）SELECTto_char(TRUNC(TO_DATE(to_char(sysdate,"yyyy-MM-dd"),"YYYY-MM-DD"),"IW")+6,"yyyy-MM-dd")FROMDUAL;--本周结束时间（本周日日期）
