Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
-- week 1
with recursive panneau(datecreation) as (
   select '2022-07-01'::timestamp
   union all
   select c.datecreation + interval '1 days' from panneau c where extract(month from c.datecreation) < 9 
)
select p.datecreation from panneau p
where date(p.datecreation) in  
  (select date(p1.dt) from (select '2022-07-05'::date - (extract(dow from '2022-07-05'::date)::text || ' days')::interval - ((7-v)::text|| ' days')::interval dt from generate_series(1,7) v) p1 where extract(month from p1.dt) = extract(month from '2022-07-05'::date - (extract(dow from '2022-07-05'::date)::text || ' days')::interval))


datecreation


2022-07-01 00:00:00

2022-07-02 00:00:00

2022-07-03 00:00:00


-- week 2
with recursive panneau(datecreation) as (
   select '2022-07-01'::timestamp
   union all
   select c.datecreation + interval '1 days' from panneau c where extract(month from c.datecreation) < 9 
)
select p.datecreation from panneau p
where date(p.datecreation) in 
  (select date(p1.dt) from (select '2022-07-12'::date - (extract(dow from '2022-07-12'::date)::text || ' days')::interval - ((7-v)::text|| ' days')::interval dt from generate_series(1,7) v) p1 where extract(month from p1.dt) = extract(month from '2022-07-12'::date - (extract(dow from '2022-07-12'::date)::text || ' days')::interval))


datecreation


2022-07-04 00:00:00

2022-07-05 00:00:00

2022-07-06 00:00:00

2022-07-07 00:00:00

2022-07-08 00:00:00

2022-07-09 00:00:00

2022-07-10 00:00:00


-- .. and week 5
with recursive panneau(datecreation) as (
   select '2022-07-01'::timestamp 
   union all 
   select c.datecreation + interval '1 days' from panneau c where extract(month from c.datecreation) < 9 
)
select p.datecreation from panneau p
where date(p.datecreation) in 
  (select date(p1.dt) from (select now() - (extract(dow from now())::text || ' days')::interval - ((7-v)::text|| ' days')::interval dt from generate_series(1,7) v) p1 where extract(month from p1.dt) = extract(month from now() - (extract(dow from now())::text || ' days')::interval))


datecreation


2022-07-25 00:00:00

2022-07-26 00:00:00

2022-07-27 00:00:00

2022-07-28 00:00:00

2022-07-29 00:00:00

2022-07-30 00:00:00

2022-07-31 00:00:00