Learn Standard SQL Functions | Interactive Course | Vertabelo Academy

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

Once again, you made it through without any problems. Good job!

In the next part, you will learn the standard function dealing with NULLs.

46/46 Congratulations

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

Congratulations, six correct answers! You now really know dates and time inside out!

That's the end of Part 4. See you in Part 5 devoted to NULLs!

Click Next exercise to finish.

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.