How to get previous date query using SQL server?

If you need to get previous  date time.(i.e., current date minus 1)

SELECT CONVERT(VARCHAR(10),DATEADD(DD, DATEDIFF(DD, 0, GETDATE()), -1),120) AS yesterday_date

select DATEADD(DD, DATEDIFF(DY, 0, GETDATE()), -1) AS yesterday_date;

OUTPUT:

if today date 18-02-2016