Declare @aDate DateTime
Set @aDate = getDate()
Declare @Minutes Integer
Set @minutes = 600 -- 10 hours

Select DateAdd(day,DateDiff(day,@aDate),0) + @minutes / 1440.0  -- 1440 min/day
 -- or You could also use the dateadd again...
Select DateAdd(minute,@minutes,DateAdd(day,0))

两者都选择在当天上午1​​0:00(或多或少)返回。这是因为，很好，检查出this SO answer

编辑：添加示例脚本以显示如何工作：

declare @dtTim datetime = getDate()
declare @today datetime = dateAdd(day,dateDiff(day,@dtTim ),0)
select  @dtTim,@today