get all the records from day before yesterday in SQL code example

Example: how to get yesterday date in sql

SELECT DATEADD(day, -1, CAST(GETDATE() AS date)) AS YesterdayDate;