3 days back in sql server
snippet in sql

datetime add 2 hours sql

user4786

DATEADD(HOUR, 2, GETUTCDATE())

3 days back in sql server

user6733

DATEADD(DAY, -3, GETDATE())

sql server today minus n

user5297

SELECT GETDATE() - 1