DATE_BUCKET – SQL Server 2022
SQL Server 2022 brings some exciting new language features such as DATE_BUCKET https://learn.microsoft.com/en-us/sql/t-sql/functions/date-bucket-transact-sql?view=sql-server-ver16 As per the information, this function returns the date-time value corresponding to the start of each date-time bucket. This means it much easier and more readable now