Comment on xkcd #2867: DateTime
ericbomb@lemmy.world 6 months ago
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 UTV and some local?”
Are all problems I do not care about.
Cosmonaut_Collin@lemmy.world 6 months ago
This is why we should just move to a universal time zone and stop with the day light savings.
nxdefiant@startrek.website 6 months ago
We have that, it’s called the Unix epoch, and the only thing it doesn’t account for is time dilation due to relativity.
phoneymouse@lemmy.world 6 months ago
If your system hasn’t been upgraded to 64-bit types by 2038, you’d deserve your overflow bug
Appoxo@lemmy.dbzer0.com 6 months ago
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
Isthisreddit@lemmy.world 6 months ago
Cries in vintage computer collection tears.
You are a monster phoneymouse
AnarchistArtificer@lemmy.world 6 months ago
I love the word “Epochalypse”, from the wiki page you linked
EatYouWell@lemmy.world 6 months ago
I thought that’s what datetime was based off of, tbh.
Cosmonaut_Collin@lemmy.world 6 months ago
I know, but it’s not standard anywhere in the world.
The_Lurker@lemmy.world 6 months ago
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?
photonic_sorcerer@lemmy.dbzer0.com 6 months ago
Give it a few more decades