Syntax

 

<modulus expression> ::=

 

<numeric value expression dividend> ::= <numeric value expression>

 

<numeric value expression divisor> ::= <numeric value expression>

 

 

Notes

 

The MOD function returns the remainder of the first argument divided by the second argument.



 

Both dividend and divisor shall be whole numbers (scale 0).



 

The divisor shall not be 0.



 

The data type of the result is the same type as the second argument.



 

If either of the arguments are null, then the result is null.



 

 

Examples

 

Expression

 

Result

 

MOD( 7, 2 )

1

MOD( 11, 4.0 )

3.0

 

 


 

Conformance

 

SQL:2003 standard

-

Feature T441 "ABS and MOD functions"