Set hour and minute to a date SQL Server

SQL Server > Datetime > Set hour and minute to a date

declare @d1 datetime

set @d1 = (Select DateAdd(hour, 6, cast(floor(cast(getdate() as float))as datetime)))

set @d1 = (Select DateAdd(minute, 45, @d1))

print @d1

Result:

Jan 23 2013 6:45AM