Dates and Times on the Horizon? Run… or Come Learn All the Traps That...
summary
A tour of how dates and times really work: explains instants, local dates/times, time zones, leap seconds and DST oddities (including historical offsets) and the 2038 problem. Compares how Java, JavaScript, Python, C# and modern SQL databases represent and store date/time values, shows common pitfalls and libraries/best practices to avoid them, and reviews various GUI date/time picker controls and their usability issues.
AI-written summary · about
chapters (18)
- 0:00Date traps intro
- 1:04Why dates are complex
- 4:34Physics and time measurement
- 8:04Time measurement history
- 12:16Time zones technical impact
- 13:43Date formats technical limits
- 17:00Famous date bugs
- 19:48Storing dates best practices
- 22:55System sync problems
- 23:39Safe time zones and pitfalls
- 24:44Dates before 1900
- 27:36Negative years errors
- 29:01Precise time measurement traps
- 32:50Duration measurement mistakes
- 34:13Leap second consequences
- 37:21Scheduling challenges
- 40:55Best practices summary
- 42:27Q&A
