SQL Server Add Hours (Minutes) to Current Date using DateAdd Function

Add Hours to Date in SQL

To add hours to date in sql server we need to write the query like as shown below

declare @hours int;

set @hours = 5;

select getdate() as currenttime, dateadd(HOUR, @hours, getdate()) as timeadded

When we run above query we will get output like as shown below

Output

Add Minutes to Date in SQL

To add minutes to date field we need to write the query like as shown below

SELECT CONVERT(VARCHAR(5),getdate(),108) OnlyTime

KANSIRIS