Modulus Expression

Wed, 03/04/2009 - 20:02 |  hdanzl


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"
‹ Absolute Value ExpressionupNatural Logarithm ›
Print this chapter |  Login or register to post comments |  Send to friend |  PDF version |  metadata Tags:
Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference | SQL Functions | Numeric Value Functions

Powered by Drupal and Drupal Theme created with Artisteer.