FLOOR()

Scalar. Returns the largest integer value less than or equal to a specific value.

Syntax

FLOOR( expression )

The following example returns the largest integer less than or equal to 3.45:

INSERT INTO OutStream
SELECT FLOOR(3.45)
FROM Devices;