Apache Drill - Math Function FLOOR(x)

The following program shows the query for this function −

Query

0: jdbc:drill:zk = local> values(floor(3.9));

Result

+---------+
| EXPR$0  |
+---------+
|   3.0   |
+---------+

The given input value 3.9 is changed to the floor value which is 3.0.