I need to get the week number in 2020 so that dates from 27th to 31st December are week 53 of 2021, 1st and 2nd January 2022 are week 1, and January 3rd is week 2.
If i use:
select to_char(to_date('20220101','YYYYMMDD'), 'IW')::int >> 52
but if i use:
select to_char(to_date('20220101','YYYYMMDD'), 'WW')::int >> 1
but
select to_char(to_date('20220110','YYYYMMDD'), 'WW')::int >> also 1
I need:
select to_char(to_date('20220101','YYYYMMDD'), 'WW')::int >> 1
select to_char(to_date('20220102','YYYYMMDD'), 'WW')::int >> 1
select to_char(to_date('20220103','YYYYMMDD'), 'WW')::int >> 2
select to_char(to_date('20220110','YYYYMMDD'), 'WW')::int >> 3