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.

2fe1b2866cfd498a513295d60d5cad0f?s=128

Joel Clermont

November 07, 2018
Tweet

Transcript

  1. 3.
  2. 4.

    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
  3. 7.

    Everything is local Pro: super easy, no thought/effort Con: What

    if you have users in a different time zone?
  4. 10.

    Local plus offset Pro: can convert to other time zones

    Con: Not consistent, lots of tz values
  5. 15.
  6. 21.

    Future as wall + tz name Pro: TZ rules can

    change Con: New time zones? God help you