Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Dates
Time
Timestamps
Extract functions
24. EXTRACT with a wrong data type
Timezone conversion
Current date and time
Review

Instruction

All right. You may wonder what happens when you try to extract a field which is not present in the given type. Is it possible to extract a year from a time column? Let's find out.

Exercise

For each route, try to extract the year from the arrival column and see what happens.