By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
MonthStart | MonthEnd | TheMonth | TheYear |
---|---|---|---|
2019-01-15 00:00:00.000 | 2019-01-31 00:00:00.000 | 1 | 2019 |
2019-02-01 00:00:00.000 | 2019-02-28 00:00:00.000 | 2 | 2019 |
2019-03-01 00:00:00.000 | 2019-03-31 00:00:00.000 | 3 | 2019 |
2019-04-01 00:00:00.000 | 2019-04-30 00:00:00.000 | 4 | 2019 |
2019-05-01 00:00:00.000 | 2019-05-31 00:00:00.000 | 5 | 2019 |
2019-06-01 00:00:00.000 | 2019-06-30 00:00:00.000 | 6 | 2019 |
2019-07-01 00:00:00.000 | 2019-07-31 00:00:00.000 | 7 | 2019 |
2019-08-01 00:00:00.000 | 2019-08-31 00:00:00.000 | 8 | 2019 |
2019-09-01 00:00:00.000 | 2019-09-30 00:00:00.000 | 9 | 2019 |
2019-10-01 00:00:00.000 | 2019-10-31 00:00:00.000 | 10 | 2019 |
2019-11-01 00:00:00.000 | 2019-11-30 00:00:00.000 | 11 | 2019 |
2019-12-01 00:00:00.000 | 2019-12-31 00:00:00.000 | 12 | 2019 |
2020-01-01 00:00:00.000 | 2020-01-31 00:00:00.000 | 1 | 2020 |
2020-02-01 00:00:00.000 | 2020-02-29 00:00:00.000 | 2 | 2020 |
2020-03-01 00:00:00.000 | 2020-03-31 00:00:00.000 | 3 | 2020 |
2020-04-01 00:00:00.000 | 2020-04-30 00:00:00.000 | 4 | 2020 |
2020-05-01 00:00:00.000 | 2020-05-31 00:00:00.000 | 5 | 2020 |
2020-06-01 00:00:00.000 | 2020-06-30 00:00:00.000 | 6 | 2020 |
2020-07-01 00:00:00.000 | 2020-07-31 00:00:00.000 | 7 | 2020 |
2020-08-01 00:00:00.000 | 2020-08-31 00:00:00.000 | 8 | 2020 |
2020-09-01 00:00:00.000 | 2020-09-30 00:00:00.000 | 9 | 2020 |
2020-10-01 00:00:00.000 | 2020-10-31 00:00:00.000 | 10 | 2020 |
2020-11-01 00:00:00.000 | 2020-11-30 00:00:00.000 | 11 | 2020 |
2020-12-01 00:00:00.000 | 2020-12-31 00:00:00.000 | 12 | 2020 |
2021-01-01 00:00:00.000 | 2021-01-31 00:00:00.000 | 1 | 2021 |
2021-02-01 00:00:00.000 | 2021-02-28 00:00:00.000 | 2 | 2021 |
2021-03-01 00:00:00.000 | 2021-03-31 00:00:00.000 | 3 | 2021 |
2021-04-01 00:00:00.000 | 2021-04-30 00:00:00.000 | 4 | 2021 |
2021-05-01 00:00:00.000 | 2021-05-31 00:00:00.000 | 5 | 2021 |
2021-06-01 00:00:00.000 | 2021-06-30 00:00:00.000 | 6 | 2021 |
2021-07-01 00:00:00.000 | 2021-07-31 00:00:00.000 | 7 | 2021 |
2021-08-01 00:00:00.000 | 2021-08-17 00:00:00.000 | 8 | 2021 |