sql – beginning of hour, month etc

Just adapt your current start of day code!

All you want is start of month, start of hour. Its just the same…

select dateadd(month, datediff(month, 0, getdate()),0) 

select dateadd(hour, datediff(hour, 0, getdate()),0)