如何在Postgres中将一个月拆分为几周

WITH weeks AS (
    SELECT
        generate_series(
            date_trunc('month', CURRENT_DATE)::date,
            date_trunc('month', CURRENT_DATE)::date + INTERVAL '1 month' - INTERVAL '1 day',
            INTERVAL '1 week'
        ) AS week_start
)
SELECT
    week_start,
    week_start + INTERVAL '6 days' AS week_end
FROM
    weeks
WHERE
    week_start + INTERVAL '6 days' <= date_trunc('month', CURRENT_DATE)::date + INTERVAL '1 month' - INTERVAL '1 day'
ORDER BY
    week_start;