Introduction
Dates
Time
11. Time in SQL
Timestamps
Extract functions
Timezone conversion
Intervals
Current date and time
Revision

Instruction

Good! Apart from dates, our database can also store time. At PerfectAir, time columns are used in the table route to indicate the estimated time of departure and arrival in Central European Time. Let's see how time is represented there.

Exercise

Select the column departure from the table route.

Console

Code editor

Result

TableConsole