cancel
Showing results for 
Search instead for 
Did you mean: 

Math MOD function

nmuppa
New Contributor

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

1 ACCEPTED SOLUTION

ForbinCSD
Contributor

@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?

View solution in original post

2 REPLIES 2

Spiro_Taleski
Valued Contributor

@nmuppa

You can use the mod(“%”) operator.

ForbinCSD
Contributor

@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?