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

xkcd

9046 readers
124 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
[–] ericbomb 123 points 1 year ago* (last edited 1 year 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.

[–] Cosmonaut_Collin 49 points 1 year 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 1 year ago* (last edited 1 year 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

[–] AnarchistArtificer 3 points 1 year 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)