this post was submitted on 14 Dec 2023
1013 points (99.2% liked)

xkcd

8979 readers
37 users here now

A community for a webcomic of romance, sarcasm, math, and language.

founded 2 years ago
MODERATORS
 

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.]

you are viewing a single comment's thread
view the rest of the comments
[โ€“] [email protected] 27 points 1 year ago* (last edited 1 year ago) (1 children)

Here's the shortlist of horrors I've had to deal with in my career:

  • Mixed US/ROW short date formats - DD/MM/YY, MM/DD/YY
  • mixed timezones in the same column
  • the wrong timezone (marked as PDT but actually UTC, or sometimes the other way around)
  • clock drift
  • timezones again...because timezones suck
  • historical timezones
  • NTP configurations

Things I've read about but haven't needed to deal with personally:

  • leap seconds
  • clock slew vs skip
  • hardware clocks
  • PTP

The one thing I really don't care about is relativity

[โ€“] [email protected] 4 points 1 year ago

it's all relative anyway