Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
3. Table aircraft
Extract functions
Timezone conversion
Current date and time


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


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.