SQL> select to_char(sysdate,'ww') from dual;TO_CHAR(SYSDATE,'WW') ---------------------------------------------- 34Elapsed: 00:00:00.10 SQL>
select to_char(sysdate,'ww') from dual;ww: Week of year (1-53) where week 1 starts on the first day of the year and continues to the seventh day of the year.
----------------------------------------------
34Elapsed: 00:00:00.10
SQL>
Week of year (1-53) where week 1 starts on the first day of the year and continues to the seventh day of the year.