MOD
Computes the modulus (remainder) of the first input divided by the second input.
Syntax
MOD(N, M)
Arguments
N
N
Type: numeric
A numeric value representing the dividend.
M
M
Type: numeric
A numeric value representing the divisor.
Returns
Type: same as input
The remainder of N
divided by M
.
Examples
N
M
Output
1
1
0
1
0
null
-1
1
0
0
0
null
3.3
1.1
1.0999999999999996
2.5
2.5
0.0
3.03
1.01
1.0099999999999998
0
2
0
9
2
1
Transformation job example
SQL
CREATE JOB function_operator_example
ADD_MISSING_COLUMNS = true
AS INSERT INTO default_glue_catalog.upsolver_samples.orders_transformed_data
MAP_COLUMNS_BY_NAME
SELECT
MOD(2.5, 2.5) AS mod_example
FROM default_glue_catalog.upsolver_samples.orders_raw_data
WHERE $commit_time BETWEEN run_start_time() AND run_end_time()
LIMIT 1;
Query result
mod_example
0.0
Last updated