Navigation:  NexusDB Guide > SQL Reference > SQL Functions > Numeric Value Functions >

Modulus Expression

 Previous pageReturn to chapter overviewNext page

NexusDB V3 Manual

Modulus Expression

button_main button_prev button_next

NexusDB Manual V3 > SQL Reference > SQL Functions > Numeric Value Functions

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"

 

© Nexus Database Systems Pty Ltd.

nexus_logo