sql-server-2008 - 如何在 SQL Server 中将小时数添加到当前日期？

Question

我正在尝试在当前时间上添加小时

-- NOT A VALID STATEMENT
-- SELECT GetDate(DATEADD (Day, 5, GETDATE()))

如何在 SQL Server 中提前几个小时？

Answer 1

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