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
36
4
10 years ago 00:07:55 2.2K
5 Tips for Undercut Hairstyle
4 years ago 00:14:25 53
Great sewing tips for sewing lovers | Sewing tips and tricks | Essential sewing tips for easier life
4 years ago 00:17:17 22
Photoshop BASIC TIPS for architects
9 years ago 00:11:36 2.6K
5 tips for better drawings
5 years ago 00:10:26 94
10 Reinhardt Tips for New Players
7 years ago 00:07:51 135
Tips and Tricks for Every Hero [Overwatch]
10 years ago 00:04:37 2.1K
Tips for Starting a Healthy Lifestyle!
11 years ago 00:08:53 117
45 Tips For Patch | Tips For #DayZ Standalone
7 years ago 00:02:49 24
The Crew 2: 5 Tips for Beginners
3 years ago 00:06:30 335
3 TIPS for EVERY SOJOURN ABILITY ft. Snowl
4 years ago 00:10:01 21
5 TIPS for Adding a Background in Photoshop
9 years ago 00:02:54 139
Quick Tips: 5 Tips For Faster Editing!
5 years ago 00:09:24 125
Cinematography Tips for Filmmakers
3 years ago 00:05:00 33
🌹 Basic Collar Sewing Tips for Beginners
8 years ago 00:13:45 60
10 Tips for After Effects
6 years ago 00:07:11 89
Sekiro: Shadows Die Twice - Essential Combat Tips For Beginners
5 years ago 00:08:36 28
Tips for League Ranked
3 years ago 00:08:22 66
10 C# tips for beginners
8 years ago 00:11:10 57
10 Tips For Clean Code
7 years ago 00:14:31 146
Tips for Mixing Bass
11 years ago 00:06:13 66
French Pronunciation Tips for Beginners
8 years ago 00:04:53 11
Tips and Tricks - 5 Tips for Cuphead
8 years ago 00:04:36 126
Tips for Beginners 2
3 years ago 00:06:42 86
✅🌺2 great zipper sewing tips/techniques for beginners