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
Dates
Time
11. Time in SQL
Timestamps
Extract functions
Timezone conversion
Current date and time
Review

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.