In every database you will find temporal data. This course teaches you how to deal with time, time zones, and more complex temporal data in PostgreSQL.

Course Overview
Overview
Date Type
Time Type
Timestamp Type
Interval Type
Date Operators and Functions
Time Operators and Functions
Timestamp Operators and Functions
Date and Timestamp Gotchas
Interval Operators and Functions
Summary
Overview
Range Types
Date Range, Range Functions, and Operators
Timestamp and Time Ranges
Overlaps Operator
Current Time
Sequence Generation
Summary
Overview
Time Zones
Time Zone Aware Types
Time Zone Conversions
Gotchas
Other Scenarios
Summary
Overview
Problems Solved with Temporal Data
Avoiding Temporal Data
Types of Time and Time-varying Tables
Constraints for Different Types of Time
Transaction Time Tables
Foreign Key Constraints
Valid Time Tables and Bitemporal Tables
SQL:2011 Temporal Features Overview
Summary
Overview
Techniques for Working with Time Values
Querying Temporal Data
Sequenced and Non-sequenced Queries
Modifying Temporal Data
Performance Considerations
Summary
Overview
Sending and Receiving Dates and Times
Concurrent Modifications
Dealing with Duplicates
Using Postgres to Help with Testing
Summary
Overview
Configuration Options
Time Zone Abbreviations
IANA Time Zone Database
Summary