----当前时间为当年第几周 Select to_char(sysdate,’WW’) from dual; ----当前时间为本月第几周 Select to_char(sysdate,’W’) from dual;