• stoly@lemmy.world
      link
      fedilink
      English
      arrow-up
      5
      ·
      9 months ago

      I was thinking to myself that this system MUST be less than 4 years old or it would have happened last February 29.

    • elmicha@feddit.de
      link
      fedilink
      English
      arrow-up
      3
      ·
      9 months ago

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