This book provides a structured approach for managing any kind of time-related data in a PostgreSQL database, including these topics:
- Date and time storage and time based calculations. - Time zones, DST and related calculations. - Storing records about things that are in effect for a period of time (like pricing, employment, contracts and many, many other things). - Keeping track of the history of changes to data across multiple tables.
Postgres provides a solid set of tools, and you will learn how to use them to maximum advantage.