dateadd(ss code example

Example 1: datetime add 2 hours sql

DATEADD(HOUR, 2, GETUTCDATE())

Example 2: sql server today minus n

SELECT GETDATE() - 1