WebSphere Message Broker, Version 8.0.0.7
Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS
See information about the latest product version
See information about the latest product version
FLOOR function
The FLOOR numeric function returns the largest integer equivalent to a given decimal number.
FLOOR returns the largest integer value less than or equal to source_number. The parameter can be any numeric data type. The result is of the same type as the parameter unless it is NULL, in which case the result is NULL.
For example:
FLOOR(1)
returns 1 FLOOR(1.2)
returns 1.0 FLOOR(-1.2)
returns -2.0If possible, the scale is changed to zero. If the result cannot be represented at that scale, it is made sufficiently large to represent the number.