- Course
PostgreSQL 9: Time and Temporal Data
In almost every database you will find time values and temporal data. This course will teach you how to deal with time, time zones, and more complex temporal data in PostgreSQL effectively.
Intermediate
- Course
PostgreSQL 9: Time and Temporal Data
In almost every database you will find time values and temporal data. This course will teach you how to deal with time, time zones, and more complex temporal data in PostgreSQL effectively.
Intermediate
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
What you'll learn
When your data has a temporal aspect, dealing with time, time zones, and time-based relationships gets very complicated quickly. In this course, PostgreSQL 9: Time and Temporal Data, you'll learn how to handle the time dimension of your data in a structured way. First, you'll learn about the date and time related types, and functions built into PostgreSQL. Next, you'll explore how to work with time zones. Finally, you'll discover how to design temporal tables, and how to query and maintain data in them. When you’re finished with this course, you'll have the skills and understanding of temporal data and time representations needed to manage temporal data effectively. Software required: PostgreSQL.
PostgreSQL 9: Time and Temporal Data
Intermediate
Table of contents
-
Version Check | 15s
-
Overview | 6m 59s
-
Date Type | 2m 48s
-
Time Type | 2m 44s
-
Timestamp Type | 1m 26s
-
Interval Type | 6m 42s
-
Date Operators and Functions | 8m 43s
-
Time Operators and Functions | 3m 10s
-
Timestamp Operators and Functions | 5m 59s
-
Date and Timestamp Gotchas | 2m 2s
-
Interval Operators and Functions | 5m 24s
-
Summary | 34s
Alex Korban is an author and consultant with an interest in functional programming, databases and geospatial applications. He co-founded a company to visualize geospatial data and wrote several books.