Returns the integer value of a numeric expression or field value.

INT(number)
Name Type Description
number numeric

The field or numeric expression to convert to an integer. If the value specified includes decimals, the decimals are truncated without rounding.

Numeric.

Basic examples

Returns 7:

INT(7.9)

Returns -7:

INT(-7.9)