subdate in sql server code example

Example: mysql subdate

SELECT SUBDATE(NOW(), INTERVAL 1 DAY);  --Yesterday