tsql date - 1 day code example

Example 1: datetime add 2 hours sql

DATEADD(HOUR, 2, GETUTCDATE())

Example 2: 3 days back in sql server

DATEADD(DAY, -3, GETDATE())