update column value today date minus 1 in SQL server query

 update column value today date minus 1 in SQL server query?

To update a column value with today's date minus one day in SQL Server, you can use the `DATEADD` function to subtract one day from the current date. Here's how you can do it:

```sql

UPDATE YourTableName

SET YourColumnName = DATEADD(day, -1, GETDATE())

WHERE YourCondition;

```

Replace `YourTableName` with the name of your table, `YourColumnName` with the name of the column you want to update, and `YourCondition` with any condition you want to apply to specify which rows should be updated.