How to create field before 1 day from field(Date)

I have a field name last_update.

I need to create new field is yesterday of last_update.

How to create?

Solution

SELECT DATEADD(DAY,-1,LAST_UPDATE)