you are viewing a single comment's thread
view the rest of the 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...

  • 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.)

  • source
  • parent