How to add hours to current date in SQL Server?

sql-server-2008

Solution

DATEADD (datepart , number , date )

declare @num_hours int; 
    set @num_hours = 5; 

select dateadd(HOUR, @num_hours, getdate()) as time_added, 
       getdate() as curr_date

Problem

I am trying to add hours to current time like ``` -- NOT A VALID STATEMENT -- SELECT GetDate(DATEADD (Day, 5, GETDATE())) ``` How can I get hours ahead time in SQL Server?

Original source