Mulai sekarangMulai gratis

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

Lihat Kursus

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
Edit dan Jalankan Kode