how to fetch yesterday date in sql code example Example: how to get yesterday date in sql SELECT DATEADD(day, -1, CAST(GETDATE() AS date)) AS YesterdayDate;