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

xkcd

8584 readers
166 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] 122 points 9 months ago* (last edited 9 months ago) (15 children)

We use datediff in sql and let God handle the rest.

"Oh but they're in different time zones" "Oh did you account for if one is in day light savings and other isn't" "Aren't some of these dates stored in UTC and some local?"

Are all problems I do not care about.

[–] [email protected] 49 points 9 months ago (14 children)

This is why we should just move to a universal time zone and stop with the day light savings.

[–] [email protected] 50 points 9 months ago* (last edited 9 months ago) (11 children)

We have that, it's called Unix time, and the only thing it doesn't account for is time dilation due to relativity.

it's perfect

[–] [email protected] 3 points 9 months ago

I love the word "Epochalypse", from the wiki page you linked

load more comments (10 replies)
load more comments (12 replies)
load more comments (12 replies)