Adding days to a date
In this exercise, you will calculate the approximate delivery date of an order based on ShipDate
.
This exercise is part of the course
Intermediate SQL Server
Exercise instructions
Write a query that returns the approximate delivery date as five days after the ShipDate
.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Return the DeliveryDate as 5 days after the ShipDate
SELECT OrderDate,
___ AS DeliveryDate
FROM Shipments