MOD

Returns the remainder of a number divided by another number.

Syntax

MOD ( float_expression , float_expression ) 

Arguments

float_expression
Is an expression of type float or of a type that can be implicitly converted to float.

Return Type

Returns values of type FLOAT64.

Examples

Examples in this section use the example blockchain.

The following example calculates the MOD for the specified components.

SELECT MOD(real, 2) FROM example;

Response:

MOD(real, 2) [FLOAT32]
NULL
0
1
0