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

xkcd

8768 readers
158 users here now

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

founded 1 year 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] 2 points 10 months ago (1 children)

i don't even care if its wrong, I just want the code to be readable.

[–] [email protected] 2 points 10 months ago (1 children)

You should care if it's wrong.

[–] [email protected] 2 points 10 months ago (1 children)

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

[–] [email protected] 1 points 10 months ago (1 children)

Clock drift? No. Time zones? Probably.

[–] [email protected] 1 points 10 months ago (1 children)

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

[–] [email protected] 1 points 10 months ago

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