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
1 view
26
3
1 month ago 00:12:05 1
ZenBusiness Review 2024: What Makes It Stand Out?
1 month ago 00:18:11 1
Framer Tutorial: Animate Buttons Like a Pro
1 month ago 00:03:02 1
SPX Options Trading : Strategies for Big Gains!
1 month ago 01:07:58 1
C’EST GRAVE! Un agent de l’ONU admet que la guerre est le seul moyen de gagner beaucoup d’argent
1 month ago 00:00:22 1
Do it! Other ways to say Daily English speaking practice English conversation
1 month ago 00:40:25 1
40MIN Unilateral Leg Strength - Lower Body Workout
1 month ago 00:14:36 1
TOP 40❗FAILS 4X4 THE CRAZIEST OFF ROAD ACCIDENTS ❌ INSANE FAILS AND WINS AMAZING VEHICLES 2024
1 month ago 00:54:03 1
CNN: “Biden devrait démissionner et installer Kamala avant la certification de l’élection“-MDL NEWS