https://xkcd.com/2867

Alt text:

It’s not just time zones and leap seconds. SI seconds on Earth are slower because of relativity, so there are time standards for space stuff (TCB, TGC) that use faster SI seconds than UTC/Unix time. T2 - T1 = [God doesn’t know and the Devil isn’t telling.]

  • KogasaEnglish
    4·
    11 months ago

    Unix epoch time in UTC, making sure that your local offset and drift are current at the time of conversion to UTC…

      • KogasaEnglish
        2·
        11 months ago

        You should care if it’s wrong.

        • Alien Nathan Edward@lemm.eeEnglish
          2·
          11 months ago

          at the resolution of clock drift in milliseconds when I’m running reports that are, at most, only specific to the day?

          • KogasaEnglish
            1·
            11 months ago

            Clock drift? No. Time zones? Probably.

            • Alien Nathan Edward@lemm.eeEnglish
              1·
              11 months ago

              not really time zones either outside the edge case where a data point exists within delta of midnight so that the time zone drift would result in a date change

              • KogasaEnglish
                1·
                11 months ago

                Time zones change. Relative times without time zones don’t make sense.