SQL UPDATE DATE

The SQL UPDATE DATE statement allows you to modify date values in a table. This is useful for correcting incorrect dates or updating timestamps for specific records. The date values can be updated dynamically using date functions.

Example

In this example, the date of an order is updated in the OrderDetails table.

-- Add a new column for order dates
ALTER TABLE Orders
ADD OrderDate DATE;

-- Update the date for specific orders
UPDATE Orders
SET OrderDate = '2024-11-21'
WHERE Product = 'Tablet';

-- View the updated table
SELECT * FROM Orders;
                

Explanation

- The ALTER TABLE statement adds a new column OrderDate to the Orders table.
- The UPDATE statement sets the date for the "Tablet" product.
- The updated table shows the new date for the specified product while other rows remain unaffected.