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


Good. Let's introduce the tables we're going to work with. A European airline called PerfectAir provided some of its data to us. Let's see what we have received from them.


Select all the information for the table route.

The table route keeps track of the destinations offered by PerfectAir. Each route has:

  • an ID code used for identification.
  • the international code of the departure airport (from_airport).
  • the international code of the arrival airport (to_airport).
  • total distance of the route (distance) expressed in kilometers.
  • departure which stores the scheduled time of departure.
  • arrival containing information about planned time of arrival.

Keep in mind that both of the time values are shown in Central European Time.