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

Standard SQL Functions

Introduction
3. Table aircraft
Dates
Time
Timestamps
Extract functions
Timezone conversion
Current date and time
Review

Instruction

Perfect, you understand the table route. Let's check another one.

Exercise

Select all the information for the table aircraft.

PerfectAir has its own fleet and each aircraft is listed in the table. An aircraft has an ID and model. The table also stores columns:

  • produced – when the production of the aircraft was officially completed and the aircraft was sold.
  • launched – when the aircraft took its first flight for PerfectAir.

These two dates may differ significantly when, e.g., PerfectAir bought a used aircraft. You may have noticed that launched is a more accurate column (it shows the time too). This is because PerfectAir wants to note the exact point in time when the aircraft took off the ground for the first time.

The last column is withdrawn – an exact point in time where the aircraft landed for the last time before it was retired.