get the date and time for today at midnight and add to it
Date now midnight time:
Select DATEADD(d,0,DATEDIFF(d,0,GETDATE()))
ADD 600 Minutes:
Select DATEADD(mi,600,DATEDIFF(d,0,GETDATE()))
Yes, just use datediff and dateadd functions to strip the time from any date, then add a fractional portion of a day to that number
Declare @aDate DateTime
Set @aDate = getDate()
Declare @Minutes Integer
Set @minutes = 600 -- 10 hours
Select DateAdd(day, DateDiff(day, 0, @aDate), 0) + @minutes / 1440.0 -- 1440 min/day
-- or You could also use the dateadd again...
Select DateAdd(minute, @minutes , DateAdd(day, DateDiff(day, 0, @aDate), 0))
Both selects return 10:00 am on the same day (more or less). This works because of, well, check out this SO answer
EDIT: Added sample script to show how this works:
declare @dtTim datetime = getDate()
declare @today datetime = dateAdd(day, dateDiff(day, 0, @dtTim ), 0)
select @dtTim, @today