Summer Deals - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
3. Table aircraft
Dates
Time
Timestamps
Extract functions
Timezone conversion
Intervals
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.