Add 1 hour to datetime column

Add an hour to datetime column with decimal value

Query

DECLARE @DateTime DATETIME = DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()), 0) SELECT       @DateTime ,     DATEADD(HOUR, 1, @DateTime) ,     @DateTime + 0.04166667

Output