Comment by ericbomb@lemmy.world on xkcd #2867: DateTime

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

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.

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

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

If your system hasn’t been upgraded to 64-bit types by 2038, you’d deserve your overflow bug

Let’s just nake it 128-Bit so it’s not our problem anymore.
Hell, let’s make it 256-Bit because it sounds like AES256

64 bits is already enough not to overflow for 292 billion years. That’s 21 times longer than the estimated age of the universe.

If you want one-second resolution, sure. If you want nanoseconds a 64-bit signed integer only gets you 292 years. With 128-bit integers you can get a range of over 5 billion years at zeptosecond (10^-21 second) resolution, which should be good enough for anyone. Because who doesn’t need to precisely distinguish times one zeptosecond apart five billion years from now‽

With a 128 bit integer you can represent 340 undecillion (or sextillion if you use the long scale notation) seconds, which is equivalent to 10 nonillion (or quintillion, long scale) years. The universe will long have have stopped being able to support life by then because stars stopped forming (enough time would have passed it could have happened a hundred quadrillion (a hundred thousand billion, long form) times over assuming we start counting from the birth of the universe).

Cries in vintage computer collection tears.

You are a monster phoneymouse

I love the word “Epochalypse”, from the wiki page you linked

I thought that’s what datetime was based off of, tbh.

I know, but it’s not standard anywhere in the world.

Give it a few more decades

Swatch’s Internet Beats are making more and sense every time Daylight Savings forces a timezones change. Why are we still using base 12 for time anyway?

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

xkcd #2867: DateTime(imgs.xkcd.com)

xkcd

!xkcd@lemmy.world

Community stats

Community moderators