Common PostgreSQL Functions | Online Course | Vertabelo Academy

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

1/54 Introduction

1. Introduction

2. The route table

3. The aircraft table

4. The flight table

5. Dates in PostgreSQL

6. The DATE data type

7. Using comparison operators with dates

8. Using BETWEEN with dates

9. Dates with ORDER BY

10. Dates – exercise

11. Time in SQL

12. The TIME data type

13. Using BETWEEN with time data

14. Comparing dates and times using operators

15. Sorting by TIME columns

16. Practice time!

17. Date and time

18. Date and time data types in PostgreSQL

19. Using date and time with constant values

20. Using operators to compare timestamps

21. Sorting timestamp data

22. Practice time!

23. The DATE_PART() function

24. DATE_PART() – example

25. DATE_PART() with the wrong data type

26. DATE_PART() with the wrong data type – continued

27. The EXTRACT() function

28. The DATE_TRUNC() function

29. The DATE_TRUNC() function – continued

30. Difference between timestamps

31. Intervals in PostgreSQL

32. INTERVAL with multiple fields

33. INTERVAL with constant values

34. INTERVAL with constant values – continued

35. Filtering with INTERVALs

36. Filtering with INTERVALs – practice

37. The OVERLAPS operator

38. The AGE() function

39. The AGE() function – continued

40. AT TIME ZONE

41. AT TIME ZONE – additional practice

42. The TO_CHAR() function

43. The TO_CHAR() function – additional practice

44. The CURRENT_TIMESTAMP and NOW() functions

45. The CURRENT_DATE and CURRENT_TIME functions

46. Current date and time with intervals – additional practice

54. Congratulations

Welcome to Part 4! We're going to get you familiarized with PostgreSQL's date and time functions. Both beginners and more advanced users will find something useful here.

Ready to get started?

Click Next exercise to continue.

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.