FLOOR

    Syntax

    FLOOR( number )
    

    Description

    Rounds the value down to the nearest integer.

    Argument types:

    • numberFractional number | Integer

    Return type: Fractional number

    Example

    [value] FLOOR([value])
    1.00 1.00
    0.10 0.00
    -2.00 -2.00
    50.50 50.00
    0.00 0.00
    -3.50 -4.00

    Data source support

    ClickHouse 19.13, Microsoft SQL Server 2017 (14.0), MySQL 5.6, PostgreSQL 9.3.