sql server today minus n
snippet in sql

sql server today minus n

user3718

SELECT GETDATE() - 1