MOD
Description
MOD
is a row function that divides two Long
values and
returns the remainder value of type Long
(the result is truncated to 0
decimal places).Syntax
MOD
(dividend
,divisor
)Return Value
Returns one value per row of type
Long
.Input Parameters
- dividend
- Required. A field or expression of typeLong.
- divisor
- Required. A field or expression of typeLong.
Examples
Cast the value of the
file_size
field to Long
and divide by
1024:MOD(TO_LONG([file_size]),1024)