如何在PostgreSQL中按天拆分时间间隔

CREATE TABLE interval_data (
    id SERIAL PRIMARY KEY,
    start_date TIMESTAMP,
    end_date TIMESTAMP
);

INSERT INTO interval_data (start_date, end_date)
VALUES
    ('2022-01-01 00:00:00', '2022-01-01 23:59:59'),
    ('2022-01-02 00:00:00', '2022-01-02 23:59:59'),
    ('2022-01-03 00:00:00', '2022-01-03 23:59:59');

SELECT
    id,
    start_date,
    end_date
FROM
    interval_data
WHERE
    start_date::DATE = '2022-01-01';

SELECT
    id,
    start_date,
    end_date,
    end_date - start_date AS duration
FROM
    (
        SELECT
            id,
            start_date,
            end_date
        FROM
            interval_data
        WHERE
            start_date::DATE = '2022-01-01'
    ) AS subquery;