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!
I want the number of weeks for a given year. I have a solution but I am not satisfied. I think it can be done much easier. Anybody an idea?
SELECT to_char(trunc(trunc(to_date('01-01-' || :jaar,'DD-MM-YYYY'),'YYYY')+3,'IW') -1,'IW') FROM dual;