INT( ) function

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

Syntax

INT(number)

Parameters

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.

Output

Numeric.

Examples

Basic examples

Returns 7:

INT(7.9)

Returns -7:

INT(-7.9)

[ Back to top ]

ACL Scripting Guide 14.1