Use this function to convert a value to an INTEGER.

Syntax

INTEGER ( convExpression )

Arguments

  • convExpression: A value to convert to INTEGER which can evaluate to any of the numeric types or a character string that is a numeric constant.

Returns

convExpression is… Returns
Numeric integer portion of the value and truncates any decimal portion
CHARACTER string length no larger than the allowed INTEGER.
NULL NULL

Examples

<ul>
  <li>convExpression:  A value to convert to INTEGER which can evaluate to any of the numeric types or a character string that is a numeric constant.</li>
</ul>