FLOORZ Function
Returns the largest integer that is less than or
equal to the argument, using zero fuzzing.
| Category: |
Truncation |
| Returned data type: |
DOUBLE |
Syntax
Arguments
expression
specifies any valid
expression that evaluates to a numeric value.
Comparisons
Unlike the FLOOR function,
the FLOORZ function uses zero fuzzing. If the argument is within 1E-12
of an integer, the FLOOR function fuzzes the result to be equal to
that integer. The FLOORZ function does not fuzz the result. Therefore,
with the FLOORZ function, you might get unexpected results.
Example
The following statements
illustrate the FLOORZ function:
|
|
|
|
|
|
|
|
|
select floorz(density) from densities; |
67
306
30
323
20
383
31
309
6
247 |