By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| n | month_start | month_end |
|---|---|---|
| 0 | 2021-12-31 23:00:00+00 | 2022-01-31 23:00:00+00 |
| 1 | 2022-01-31 23:00:00+00 | 2022-02-28 23:00:00+00 |
| 2 | 2022-02-28 23:00:00+00 | 2022-03-31 23:00:00+01 |
| 3 | 2022-03-31 23:00:00+01 | 2022-04-30 23:00:00+01 |
| 4 | 2022-04-30 23:00:00+01 | 2022-05-31 23:00:00+01 |
| 5 | 2022-05-31 23:00:00+01 | 2022-06-30 23:00:00+01 |
| 6 | 2022-06-30 23:00:00+01 | 2022-07-31 23:00:00+01 |
| 7 | 2022-07-31 23:00:00+01 | 2022-08-31 23:00:00+01 |
| 8 | 2022-08-31 23:00:00+01 | 2022-09-30 23:00:00+01 |
| 9 | 2022-09-30 23:00:00+01 | 2022-10-31 23:00:00+00 |
| 10 | 2022-10-31 23:00:00+00 | 2022-11-30 23:00:00+00 |
| 11 | 2022-11-30 23:00:00+00 | 2022-12-31 23:00:00+00 |
| 12 | 2022-12-31 23:00:00+00 | 2023-01-31 23:00:00+00 |
SELECT 13
| monthrange |
|---|
| ["2021-12-31 23:00:00+00","2022-01-31 23:00:00+00") |
| ["2022-01-31 23:00:00+00","2022-02-28 23:00:00+00") |
| ["2022-02-28 23:00:00+00","2022-03-31 23:00:00+01") |
| ["2022-03-31 23:00:00+01","2022-04-30 23:00:00+01") |
| ["2022-04-30 23:00:00+01","2022-05-31 23:00:00+01") |
| ["2022-05-31 23:00:00+01","2022-06-30 23:00:00+01") |
| ["2022-06-30 23:00:00+01","2022-07-31 23:00:00+01") |
| ["2022-07-31 23:00:00+01","2022-08-31 23:00:00+01") |
| ["2022-08-31 23:00:00+01","2022-09-30 23:00:00+01") |
| ["2022-09-30 23:00:00+01","2022-10-31 23:00:00+00") |
| ["2022-10-31 23:00:00+00","2022-11-30 23:00:00+00") |
| ["2022-11-30 23:00:00+00","2022-12-31 23:00:00+00") |
| ["2022-12-31 23:00:00+00","2023-01-31 23:00:00+00") |
SELECT 13