`floor({n})`

Returns the nearest integer of equal or lesser value to n. n can be any real numeric value in the range of -1.797e308<= n <= 1.797e308.

floor({n}) takes the following syntax.

1SELECT floor(COLUMN_NAME) as ALIASNAME
2FROM DATASET;

Example

This example returns values in the Discount field rounded down to the nearest integer. In the first three rows, the Discount value is 0. The fourth and fifth values are 0.45 and 0.2, respectively, which are rounded to 0.

1SELECT floor(Discount) as floorDiscount
2FROM Superstore
3LIMIT 5;

floorDiscount
0
0
0
0
0