Just store UTC? Handling Time Zones & Daylight Saving

Опубликовано: 09 Октябрь 2024
на канале: CodeOpinion

32,289

1.1k

Should you store dates & times in your database as UTC? It's pretty standard advice if you're working in a system that needs to record dates and times from many different time zones. But this advice doesn't really hold true when you're dealing with dates and times in the future; here are some things you need to consider.

🔗 EventStoreDB
https://eventsto.re/codeopinion

🔔 Subscribe:    / @codeopinion

💥 Join this channel to get access to source code & demos!
   / @codeopinion

🔥 Don't have the JOIN button? Support me on Patreon!
  / codeopinion

📝 Blog: https://codeopinion.com
👋 Twitter:   / codeopinion
✨ LinkedIn:   / dcomartin
📧 Weekly Updates: https://mailchi.mp/63c7a0b3ff38/codeo...

0:00 Intro
0:36 Saving as UTC
2:17 Time zones & Daylight Saving Time
4:17 Time Zone Database

#softwarearchitecture #softwaredesgin #codeopinion