Return start of the week, 2025-03-31T00:00:00.000000Z

SELECT date_trunc('week', now());

Return minus 7 days, 2025-03-28T09:55:31.120396Z

SELECT dateadd('d', -7, now());