FLOOR

FLOOR (expression)

Parameters

• expression - any valid numeric expression.

Description

See also Java Math.floor. This method returns a double.

Example

Calculates floor price:

SELECT FLOOR(X) FROM Items;