Want to learn more Postgres? Get on the waiting list for the full course: . Production ready Postgres for teams that ship fast: In this video, I'll show you how to keep your sanity by using best practices (aka the least frustrating way) to handle timezones in PostgreSQL! Follow me: Twitter: LinkedIn: Website: - find articles, podcasts, courses, and more. Chapters: 00:00 - Introduction to Time Zones in PostgreSQL 00:51 - Why Time Zones Are Frustrating 01:42 - Best Practices for Handling Time Zones 02:24 - Using UTC for Consistency 03:04 - Setting the Time Zone for Your Database and Session 04:07 - Impact of Session Time Zone on Timestamps 05:00 - How PostgreSQL Stores and Displays Timestamps 06:03 - Converting UTC to Local Time Zones 06:40 - The Importance of Using Named Time Zones 07:06 - Using at time zone for Conversion 07:59 - Potential Pitfalls of Using Abbreviations (CST/CDT) 08:58 - The Problem with Hour Offsets 10:30 - Understanding Posix Style Time Zone Specifications 11:55 - Avoiding Mistakes with Time Zone Offsets 12:46 - Listing and Selecting Time Zone Names in PostgreSQL 13:39 - Final Recommendations for Handling Time Zones
Hide player controls
Hide resume playing