Cacher is the code snippet organizer for pro developers

--SOURCE https://stackoverflow.com/a/18518412

Declare @num_hours int; 
    set @num_hours = 5; 

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