192
Sysadmins slam Apple’s SSL/TLS cert lifespan cuts (www.theregister.com)
submitted 2 years ago by to c/technology@lemmy.world
81 comments fedilink hide all child comments
you are viewing a single comment's thread
view the rest of the comments
[–] 3 points 2 years ago (2 children)

Unrelated to the topic, but I deal with a database storing timestamps.

In local time.

For systems all around the world.

You'll see current entries timestamped 12:28 from eastern Europe followed by ones 6:28 from America and then another 11:28 from central Europe.

Without offset.

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 2 child comments
    •
  • [–] 4 points 2 years ago (1 child)

    Ew. Just store UTC timestamps and do optional translation on the client using whatever the client sets up for their timezone. It's not hard...

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 1 child comment
    •
  • [–] 2 points 2 years ago

    Oh believe me, I would change some things about that database if I could. Alas, I'm just the analyst building data models from it.

    (To be fair, it's otherwise easy to work with and for most use-cases, it doesn't matter since they're aggregated per month anyway, so I just load the last month's data on the 2nd of each month. I definitely have worse patients to operate on.)

  • permalink
  • fedilink
  • source
  • parent