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)

SSRS Query execution failed for dataset
Insert leading spaces, then the value to a varchar(10) column
How to use order by with union all in sql?
Is it good to create a nonclustered index on a column of type varchar?
Unable to install SQL Server(setup.exe) Exit code decimal: -2061893606
No PK or FK when exporting SQL Server database
SQL Server SELECT LAST N Rows
Order by Specific id first then By rest
Fuzzy phrase similarity in SQL Server
Union two selects removing duplicates base on some columns (not the full row)
SQL fill gaps with hold
Create login and logout rows from single row
Create Index without name while creating table
Extracting SQL Server table data to parquet file
SQL, How to convert VARCHAR to bigint?
PHP and SQL Shopping Cart is Not Adding Products to Shopping Cart
SQL Server query to find all permissions/access for all users in a database
How to merge 2 or more rows and SUM a column in an UPDATE without a primary key?
How can I update top 100 records in SQL server?
inserting data into SQL DB from C# ASP.NET
Display the average number of days between a customer's last and second to the last transaction
Fastest way to determine if record exists
Unrecognized column name that I define
What are the advantages of running SQL Server in a Docker container?
How do I get the MAX of two values in SQL Server?
How can I split a single, very long string into separate columns and rows delimited by commas and semicolons in SQL Server?
Why can't I use table names of aliased tables in WHERE clause?
Function vs. Stored Procedure in SQL Server
How to correctly join two tables that each have Start Date and Stop Date columns?
How to run sql script using SQL Server Management Studio?