INT

    Type conversion functions

    Syntax

    INT( expression )
    

    Description

    Converts the expression expression to integer format according to the following rules:

    Type Value
    Number (whole) Original value
    Number (decimal) Integer part of the number (rounded down)
    Date | Datetime Unix time corresponding to the date and time. If the value contains time zone data, it's used in the calculation. If the time zone is unknown, the time is set in UTC
    String A number from a decimal string
    Boolean TRUE — 1, FALSE — 0

    Argument types:

    • expressionBoolean | Date | Datetime | Number | String

    Return type: Number (whole)

    Examples

    INT(7.7) = 7
    
    INT("365") = 365
    
    INT(TRUE) = 1
    

    Data source support

    Materialized Dataset, ClickHouse 1.1, Microsoft SQL Server 2017 (14.0), MySQL 5.6, PostgreSQL 9.3