Adding days to a date
In this exercise, you will calculate the approximate delivery date of an order based on ShipDate.
Latihan ini merupakan bagian dari kursus
Intermediate SQL Server
Instruksi latihan
Write a query that returns the approximate delivery date as five days after the ShipDate.
Latihan interaktif langsung praktik
Cobalah latihan ini dengan melengkapi kode contoh ini.
-- Return the DeliveryDate as 5 days after the ShipDate
SELECT OrderDate,
___ AS DeliveryDate
FROM Shipments