Counting the number of days between dates
In this exercise, you will calculate the difference between the order date and ship date.
Latihan ini merupakan bagian dari kursus
Intermediate SQL Server
Instruksi latihan
Write a query that returns the number of days between OrderDate and ShipDate.
Latihan interaktif langsung praktik
Cobalah latihan ini dengan melengkapi kode contoh ini.
-- Return the difference in OrderDate and ShipDate
SELECT OrderDate, ShipDate,
___(___, OrderDate, ShipDate) AS Duration
FROM Shipments