Comment on xkcd #2867: DateTime
ericbomb@lemmy.world 11 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 11 months ago
This is why we should just move to a universal time zone and stop with the day light savings.
nxdefiant@startrek.website 11 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 11 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 11 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 11 months ago
Cries in vintage computer collection tears.
You are a monster phoneymouse
AnarchistArtificer@lemmy.world 11 months ago
I love the word “Epochalypse”, from the wiki page you linked
EatYouWell@lemmy.world 11 months ago
I thought that’s what datetime was based off of, tbh.
Cosmonaut_Collin@lemmy.world 11 months ago
I know, but it’s not standard anywhere in the world.
The_Lurker@lemmy.world 11 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 11 months ago
Give it a few more decades