Syntax

FLOOR( X)

Returns the largest integer value not greater than X. 

Example  

SELECT FLOOR(1.99);
->1
SELECT FLOOR(-1.23);
->-2

Related

• SQL Reference
• SQL Functions and Operators