• elmicha@feddit.de
    link
    fedilink
    English
    arrow-up
    2
    ·
    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.