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