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


  1. 3.
  2. 4.

    Date time values are tricky • Date math • Leap

    years/seconds • Daylight Saving Time • Time Zones • Many more . . . 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