Comment

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.

source

Sort:hotnew top

Cosmonaut_Collin@lemmy.world ⁨1⁩ ⁨year⁩ ago
This is why we should just move to a universal time zone and stop with the day light savings.

source
- nxdefiant@startrek.website ⁨1⁩ ⁨year⁩ 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.
  
  source
  - phoneymouse@lemmy.world ⁨1⁩ ⁨year⁩ ago
    If your system hasn’t been upgraded to 64-bit types by 2038, you’d deserve your overflow bug
    
    source
    Appoxo@lemmy.dbzer0.com ⁨1⁩ ⁨year⁩ 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
    
    source
    -> View More Comments
    Isthisreddit@lemmy.world ⁨1⁩ ⁨year⁩ ago
    Cries in vintage computer collection tears.
    
    You are a monster phoneymouse
    
    source
  - AnarchistArtificer@lemmy.world ⁨1⁩ ⁨year⁩ ago
    I love the word “Epochalypse”, from the wiki page you linked
    
    source
  - EatYouWell@lemmy.world ⁨1⁩ ⁨year⁩ ago
    I thought that’s what datetime was based off of, tbh.
    
    source
  - Cosmonaut_Collin@lemmy.world ⁨1⁩ ⁨year⁩ ago
    I know, but it’s not standard anywhere in the world.
    
    source
- The_Lurker@lemmy.world ⁨1⁩ ⁨year⁩ 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?
  
  source
- photonic_sorcerer@lemmy.dbzer0.com ⁨1⁩ ⁨year⁩ ago
  Give it a few more decades
  
  source