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

xkcd

8791 readers
130 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] 120 points 11 months ago* (last edited 11 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] 48 points 11 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] 49 points 11 months ago* (last edited 11 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 10 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)