numericExpression must be of data type INTEGER. Other data types are not allowed but can be converted to an integer using the INT() function.

If the result of the conversion exceeds the allowable values for a SMALLINT, an overflow condition occurs. The valid range is -32768 through 32767.

Important

If the argument is a constant, then it must adhere to integer value rules. Specifying SMALLINT(1.5) causes an error because 1.5 is not an integer.