floor function
Derby Reference Manual
326
Returns e raised to the power of the specified number.
exp(number)
The JDBC escape syntax
{fn exp(number)}
is equivalent to the built-in syntax
EXP(number)
. For more information, see
floor
Rounds the specified number down, and returns the largest number that is less than
or equal to the specified number.
floor(number)
The JDBC escape syntax
{fn floor(number)}
is equivalent to the built-in syntax
FLOOR(number)
. For more information, see
log
Returns the natural logarithm (base e) of the specified number.
log(number)
The JDBC escape syntax
{fn log(number)}
is equivalent to the built-in syntax
LOG(number)
. For more information, see
.
log10
Returns the base-10 logarithm of the specified number.
log10(number)
The JDBC escape syntax
{fn log10(number)}
is equivalent to the built-in syntax
LOG10(number)
. For more information, see
.
mod
Returns the remainder (modulus) of argument 1 divided by argument 2. The result is
negative only if argument 1 is negative.
mod(integer_type, integer_type)
The JDBC escape syntax
{fn mod(integer_type, integer_type)}
is
equivalent to the built-in syntax
MOD(integer_type, integer_type)
. For more
information, see
pi
Returns a value that is closer than any other value to pi.
pi()
The JDBC escape syntax
{fn pi()}
is equivalent to the built-in syntax
PI()
. For
.
radians
Converts a specified number from degrees to radians.
radians(number)
The JDBC escape syntax
{fn radians(number)}
is equivalent to the built-in
syntax
RADIANS(number)
. For more information, see
.
rand
Returns a random number given a seed number.
rand(seed)
The JDBC escape syntax
{fn rand(seed)}
is equivalent to the built-in syntax
RAND(seed)
. For more information, see
.
