FLOOR returns the largest integer not greater than the argument’s value. The result is cast to the specified type:Decimal FLOOR( value Decimal )Double FLOOR( value Double )CEILING returns the smallest integer not less than the argument’s value. The result is cast to the specified type:Decimal CEILING( value Decimal )Double CEILING( value Double )Integer MOD( v1 Integer, v2 Integer )For decimal data types, the result’s precision and scale for the FLOOR and CEILING functions are (p + 1, s), where (p, s) are the precision and scale of the operand.
|
|
Copyright Actuate Corporation 2012 |