how to add days to a date column in sql code example

Example 1: datetime add 2 hours sql

DATEADD(HOUR, 2, GETUTCDATE())

Example 2: sql server today minus n

SELECT GETDATE() - 1