INTEGER or INT

The INTEGER function returns an integer representation of a number. The argument can be either a string expression or a numeric expression.

Related topics

Functions-that-the-BMC-AMI-Utilities-SQL-language-supports

Features-that-the-BMC-AMI-Utilities-SQL-language-supports

INTEGER.png


The arguments are defined as follows:

numericExpression

numericExpression is converted to an integer from one of the following numerical data types:

  • SMALLINT
  • INTEGER
  • BIGINT
  • FLOAT
  • REAL
  • DECIMAL
  • DECFLOAT

The numeric expression is not rounded before conversion and any fractional part is truncated. If the result exceeds the allowable values for an integer, an overflow condition will occur. The valid range is -2147483648 through 2147483647.

Important

If the argument can be null, the result can be null; if the argument value is null, the result is the null value. If the argument is a constant, it must adhere to integer value rules. Specifying INT(1.5) causes an error because 1.5 is not an integer.

stringExpression

If the argument is a string expression, it can be in any external numerical format. It is first converted to its corresponding format, and then converted to an integer. If the CCSID of the string is not in EBCDIC encoding scheme, CCSID is cast to EBCDIC before conversion takes place.

 

  • 13.1
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*