Numeric
You can assign any numeric data type to any other numeric data type. You can assign a money value to any numeric data type and a numeric value to the money data type. Numeric assignments have the following characteristics:
• The DBMS Server can truncate leading zeros or all or part of the fractional part of a number if necessary. If the non-fractional part of a value (other than leading zeros) is truncated, an overflow error results. (These errors are reported only if the -numeric_overflow flag is set. For information about the -numeric_overflow flag, see the quel command description in the Command Reference Guide.)
• When a float, float4, or money value is assigned to an integer column or variable, the fractional part is truncated.