FLOOR function
Derby Reference Manual
128
The result of the function is a double-precision floating-point number. The result can be
null; if the argument is null, the result is the null value. The result is the same number that
would occur if the string was considered a constant and assigned to a double-precision
floating-point column or variable.
EXP function
The EXP function returns e raised to the power of the specified number.
The specified number is the exponent that you want to raise e to. The specified number
must be a
number.
The constant e is the base of the natural logarithms.
The data type of the returned value is a DOUBLE PRECISION number.
Syntax
EXP ( number )
FLOOR function
The FLOOR function rounds the specified number down, and returns the largest number
that is less than or equal to the specified number.
The specified number must be a
· If the specified number is NULL, the result of this function is NULL.
· If the specified number is equal to a mathematical integer, the result of this function
is the same as the specified number.
· If the specified number is zero (0), the result of this function is zero.
The returned value is the largest (closest to positive infinity) double floating point value
that is less than or equal to the specified number. The returned value is equal to a
mathematical integer. The data type of the returned value is a DOUBLE PRECISION
number.
Syntax
FLOOR ( number )
HOUR function
The HOUR function returns the hour part of a value.
The argument must be a time, timestamp, or a valid character string representation of a
time or timestamp that is not a CLOB, LONG VARCHAR, or XML value. The result of the
function is an integer between 0 and 24. If the argument can be null, the result can be
null; if the argument is null, the result is the null value.
Syntax
HOUR ( expression )
Example
Select all the classes that start in the afternoon from a table called TABLE1.
SELECT * FROM TABLE1 WHERE HOUR(STARTING) BETWEEN 12 AND 17
IDENTITY_VAL_LOCAL function
