Learn Standard SQL Functions | Interactive Course | Vertabelo Academy

Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

24/46 EXTRACT with a wrong data type

1. Introduction

3. Table aircraft

4. Table flight

5. Dates in SQL

6. Date format explained

7. Dates with logical operators

8. Dates with BETWEEN

9. Dates with ORDER BY

10. Dates – additional practice

11. Time in SQL

12. Time with logical operators

13. Time with BETWEEN

14. Time with ORDER BY

15. TIME – additional practice

17. Timestamps explained

18. Timestamps with constant values

19. Timestamps with BETWEEN

20. Timestamps with ORDER BY

21. Timestamps – additional practice

22. EXTRACT(field FROM column)

23. EXTRACT – example

24. EXTRACT with a wrong data type

25. EXTRACT with a wrong data type – continued

26. AT TIME ZONE

27. AT TIME ZONE – additional practice

28. Difference between timestamps

29. INTERVAL YEAR TO MONTH

30. INTERVAL DAY TO SECOND

31. INTERVAL 'x' FIELD

32. INTERVAL with constant values

33. INTERVAL with constant values – continued

34. INTERVALs with comparison operators

35. INTERVALs with comparison operators – additional practice

36. Current_date, current_time and current_timestamp

37. Current date & time with intervals

38. Current date & time with intervals – additional practice

46. Congratulations

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.

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

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings.You can modify your browser settings on your own. For more information see our Privacy Policy.