Learn Standard SQL Functions | Interactive Course | Vertabelo Academy

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

10/46 Dates – additional practice

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. BETWEEN WITH INTERVALS

35. BETWEEN WITH INTERVALS – 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

Okay, let's try a more complicated example for additional practice.

For each aircraft produced in 2010, show its id, production date and the distinctive codes of routes they operate on (rename the column to route_code).

For distinctive codes, use DISTINCT. In order to show the codes, you will need to JOIN two tables.

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.