Upgrade to Pro — share decks privately, control downloads, hide ads and more …

How to Save Time

How to Save Time

This isn't a productivity talk. It's a survey of some idiosyncrasies related to persisting date/time values to a database.

Joel Clermont

November 07, 2018
Tweet

More Decks by Joel Clermont

Other Decks in Technology

Transcript

  1. Date time values are tricky • Date math • Leap

    years/seconds • Daylight Saving Time • Time Zones • Many more . . . https://infiniteundo.com/post/25326999628/falsehoods- programmers-believe-about-time
  2. Everything is local Pro: super easy, no thought/effort Con: What

    if you have users in a different time zone?
  3. Local plus offset Pro: can convert to other time zones

    Con: Not consistent, lots of tz values
  4. Future as wall + tz name Pro: TZ rules can

    change Con: New time zones? God help you