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

Comparisons

Example

Syntax

FLOORZ(expression)

Arguments

expression

specifies any valid expression that evaluates to a numeric value.

Data type	DOUBLE
See	<sql-expression>
See	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

FLOORZ Function

Syntax

Arguments

expression

Comparisons

Example

See Also