Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Finding the number of weeks in a given year

MartijnkeJan 6 2020 — edited Jan 7 2020

Hi all,

I need to find the number of weeks for a given year as it can be 52 or 53 when using ISO (IW)

I thought of asking the week number for dec 31st but for 2019 that returns iso week 1 (of iso year 2020) :

select to_number(to_char(to_date('31/12/2019', 'DD/MM/YYYY'), 'IW')) a

from dual;

this returns 1 and doesn't help me

any ideas

Comments
Post Details
Added on Jan 6 2020
9 comments
1,363 views