add 30 minutes to datetime in sql server code example
Example 1: datetime add 2 hours sql
DATEADD(HOUR, 2, GETUTCDATE())
Example 2: sql server today minus n
SELECT GETDATE() - 1
DATEADD(HOUR, 2, GETUTCDATE())
SELECT GETDATE() - 1