FLOOR

The FLOOR function rounds the specified number down, and returns the largest number that is less than or equal to the specified number.

Syntax

FLOOR ( number )

number

A  DOUBLE PRECISION number.

Example

splice> VALUES FLOOR(84.4);
1
----------
84

1 row selected

Results

The data type of the result is a  DOUBLE PRECISION number. The returned value is equal to a mathematical integer.

  • 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.

See Also