subtract/add 1 hour/day to current time sql server - Use DATEADD

Use DATEADD

To subtract a hour
select DATEADD(hh,-1,getdate())

To add a hour
select DATEADD(hh,1,getdate())

To add a day
select DATEADD(dd,1,getdate())