Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Common Functions in MS SQL Server

Introduction
3. The Aircraft table
Dealing with dates
Working with time data
Date and time date
Extracting dates and times
Doing arithmetic with dates
Converting date and time data
Building date and time data from parts
Summary and review

Instruction

Perfect! Now you know the Route table. Let's check another table.

Exercise

Select all information from the Aircraft table. PerfectAir has its own fleet, and each aircraft is listed in the table. The table contains the following information:

  • an internal ID number for the aircraft (Id),
  • the aircraft's make and model (Model),
  • the date when production on that aircraft was completed (ProducedDate),
  • the date when the aircraft took its first flight for PerfectAir (LaunchedDatetime),
  • the date when that aircraft finished its final PerfectAir flight (DiscontinuationDatetime).

Note that the ProducedDate and LaunchedDatetime dates may differ significantly (e.g., if PerfectAir bought a used aircraft).

You may have noticed that LaunchedDatetime is a more accurate column (it shows the date and the time). This is because PerfectAir wants to mark the exact moment of the aircraft's first takeoff.