fne8w2ah@lemmy.world to World News@lemmy.worldEnglish · 8 months agoLeap year software glitch closes fuel pumps across New Zealandwww.straitstimes.comexternal-linkmessage-square5fedilinkarrow-up197arrow-down13
arrow-up194arrow-down1external-linkLeap year software glitch closes fuel pumps across New Zealandwww.straitstimes.comfne8w2ah@lemmy.world to World News@lemmy.worldEnglish · 8 months agomessage-square5fedilink
minus-squareelmicha@feddit.delinkfedilinkEnglisharrow-up3·8 months agoI hit a similar bug today where I had used SYSDATE - NUMTOYMINTERVAL(2, 'year') in Oracle. I don’t remember why I didn’t use sysdate - 2*365 instead, which works without problems for my use case (I don’t care about one day more or less). But I would have appreciated if the compiler or the IDE would have yelled at me.
I hit a similar bug today where I had used
in Oracle. I don’t remember why I didn’t use
sysdate - 2*365instead, which works without problems for my use case (I don’t care about one day more or less). But I would have appreciated if the compiler or the IDE would have yelled at me.