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