• lennivelkant@discuss.tchncs.de
    link
    fedilink
    English
    arrow-up
    3
    ·
    1 day ago

    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.

    • sugar_in_your_tea@sh.itjust.works
      link
      fedilink
      English
      arrow-up
      4
      ·
      24 hours ago

      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…