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

FLOORZ(expression)

Arguments

expression

specifies any valid expression that evaluates to a numeric value.

Data type DOUBLE
See <sql-expression>
FedSQL Expressions

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

Table: DENSITIES
The following statements illustrate the FLOORZ function:
Statements
Results
select floorz(-2.4);
-3
select floorz(-1.6);
-2
select floorz(density) from densities;
67
306
30
323
20
383
31
309
6
247
Last updated: February 23, 2017