Forum Discussion

nmuppa's avatar
nmuppa
New Contributor
3 years ago
Solved

Math MOD function

how to implement MOD (math) functionality in Snaplogic in different
queries as well as using functions

  • @nmuppa - you mentioned queries.

    Exactly what are you looking for here?

    “%” is the modulus operator in JavaScript, Ruby, and Python.

    If you really mean “queries,” which database system are you querying?

    Microsoft SQL Server uses the % operator as well, AFAICR.
    Oracle and PostgreSQL use a MOD() function.
    MySQL uses a dyadic MOD operator (dividend MOD divisor).
    Other DBMSes may use something entirely different, like “remainder”.

    Or did you really mean you want to implement a modulus function? From scratch?

2 Replies

  • @nmuppa - you mentioned queries.

    Exactly what are you looking for here?

    “%” is the modulus operator in JavaScript, Ruby, and Python.

    If you really mean “queries,” which database system are you querying?

    Microsoft SQL Server uses the % operator as well, AFAICR.
    Oracle and PostgreSQL use a MOD() function.
    MySQL uses a dyadic MOD operator (dividend MOD divisor).
    Other DBMSes may use something entirely different, like “remainder”.

    Or did you really mean you want to implement a modulus function? From scratch?