INT

Syntax

INT( expression )

Description

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

Type Value
Integer Original value.
Fractional number 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 TRUE1, FALSE0.

Argument types:

  • expressionBoolean | Date | Datetime | Fractional number | Integer | String

Return type: Integer

Examples

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

Data source support

ClickHouse 21.8, Microsoft SQL Server 2017 (14.0), MySQL 5.7, Oracle Database 12c (12.1), PostgreSQL 9.3, YDB.

Previous
Next