Postgres 16

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
    SELECT  Q_Start::DATE, 
            ((Q_Start + INTERVAL '3 months') - INTERVAL '1 day')::DATE Q_End, 
            RANK()OVER(ORDER BY Q_Start DESC) Q_Rank
    FROM    GENERATE_SERIES(DATE_TRUNC('year', CURRENT_DATE) - INTERVAL '1 year', 
                            DATE_TRUNC('quarter', CURRENT_DATE), 
                            INTERVAL '3 months')_(Q_Start)


q_start
q_end
q_rank


2024-01-01
2024-03-31
1

2023-10-01
2023-12-31
2

2023-07-01
2023-09-30
3

2023-04-01
2023-06-30
4

2023-01-01
2023-03-31
5



SELECT 5


    SELECT  Q_Start::DATE, 
            (Q_Start + INTERVAL '3 months -1 day')::DATE Q_End, 
            RANK()OVER(ORDER BY Q_Start DESC) Q_Rank
    FROM    GENERATE_SERIES(DATE_TRUNC('year', CURRENT_DATE) - INTERVAL '1 year', 
                            DATE_TRUNC('quarter', CURRENT_DATE), 
                            INTERVAL '3 months')_(Q_Start)


q_start
q_end
q_rank


2024-01-01
2024-03-31
1

2023-10-01
2023-12-31
2

2023-07-01
2023-09-30
3

2023-04-01
2023-06-30
4

2023-01-01
2023-03-31
5



SELECT 5


    SELECT  Q_Start::DATE, 
            (Q_Start + INTERVAL '3 months -1 day')::DATE Q_End, 
            Q_Rank
    FROM    GENERATE_SERIES(DATE_TRUNC('quarter',CURRENT_DATE),
                            DATE_TRUNC('year',   CURRENT_DATE) - INTERVAL '1 year', 
                            INTERVAL '-3 months') WITH ORDINALITY g(Q_Start, Q_Rank)


q_start
q_end
q_rank


2024-01-01
2024-03-31
1

2023-10-01
2023-12-31
2

2023-07-01
2023-09-30
3

2023-04-01
2023-06-30
4

2023-01-01
2023-03-31
5



SELECT 5


    SELECT  Q_Start::DATE, 
            (Q_Start + '3 months -1 day')::DATE Q_End, 
            Q_Rank
    FROM    GENERATE_SERIES(DATE_TRUNC('quarter',CURRENT_DATE),
                            DATE_TRUNC('year',   CURRENT_DATE) - INTERVAL '1 year', 
                            INTERVAL '-3 months') WITH ORDINALITY g(Q_Start, Q_Rank)


q_start
q_end
q_rank


2024-01-01
2024-03-31
1

2023-10-01
2023-12-31
2

2023-07-01
2023-09-30
3

2023-04-01
2023-06-30
4

2023-01-01
2023-03-31
5



SELECT 5
q_start	q_end	q_rank
2024-01-01	2024-03-31	1
2023-10-01	2023-12-31	2
2023-07-01	2023-09-30	3
2023-04-01	2023-06-30	4
2023-01-01	2023-03-31	5