zaagan
3/15/2018 - 10:27 AM

DateTime Manipulation

DateTime Manipulation



--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