FLOOR

✅ Azure Stream Analytics ✅ Fabric Eventstream

A mathematical function that returns the largest integer less than or equal to the specified numeric expression.

Syntax

FLOOR (expression)  

Argument

expression

Is an expression of the exact numeric or approximate numeric data type category.

Return Type

Returns the same type as submitted in expression.

Example

SELECT FLOOR(input.x) AS "The FLOOR of the variable x"  
FROM input