Storing Times for Human Events

Viewed 165
The discussion centers around the complexities and importance of storing time data correctly for human events. Key points made include the necessity of accounting for timezones, daylight savings changes, and the perception of time by humans. It highlights the limitations of current storage approaches like `timestamptz`, the need for a high-quality time library, and the potential pitfalls when not considering these factors. Notably, there are suggestions to implement a 'time' type independent of timezone for recurring events, and the idea of using specifications like ISO8601 for accurate time representation is praised.
0 Answers