Introduction
Dates
Time
Timestamps
Extract functions
24. EXTRACT with a wrong data type
Timezone conversion
Intervals
Current date and time
Revision

Instruction

Alright. 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.

Console

Code editor

Result

TableConsole