By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| current timestamp | getdate | months from zero | day 1 last month | day 1 this month |
|---|---|---|---|---|
| 2023-07-22 01:07:00.753 | 2023-07-22 01:07:00.753 | 1482 | 2023-06-01 00:00:00.000 | 2023-07-01 00:00:00.000 |