select dateadd(hour,7,getdate())
DECLARE @date DATETIME SET @date='2010-10-01' SET @date=@date+'15:00:00' SELECT @date AS DATETIME
ADDTIME(NOW(),'5:30:00')