add 30 days to getdate in sql 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())
DATEADD(HOUR, 2, GETUTCDATE())
DATEADD(DAY, -3, GETDATE())