출처 : http://www.techonthenet.com/oracle/functions/mod.php

Oracle/PLSQL: Mod Function


In Oracle/PLSQL, the mod function returns the remainder of m divided by n.

The syntax for the mod function is:

mod( m, n )

The mod is calculated as:

m - n * floor(m/n)


Note:

The mod function uses the floor function in its formula, whereas the remainder function uses the round function in its formula.

The mod function returns m if n is 0.


Applies To:

  • Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g

For example:

mod(15, 4) would return 3
mod(15, 0) would return 15
mod(11.6, 2) would return 1.6
mod(11.6, 2.1) would return 1.1
mod(-15, 4) would return -3
mod(-15, 0) would return -15

저작자 표시
신고
posted by 뚱2