Floating-point or decimal to integer

When a single precision floating-point number is converted to integer, rounding occurs on the seventh significant digit, zeros are added to the end of the number, if necessary, starting from the seventh significant digit, and the fractional part of the number is eliminated. When a double precision floating-point or decimal number is converted to integer, the fractional part of the number is eliminated.

Example 1: The following example shows single precision floating-point numbers converted to an integer:

Floating-point number:           Results when assigned to an integer column
                                  or host variable:
2.0000045E6                      2000000
2.00000555E8                     200001000

Example 2: The following example shows a double precision floating-point number converted to an integer:

Floating-point number:           Results when assigned to an integer column
                                  or host variable:
2.0000045E6                      2000004
2.00000555E8                     200000555

Example 3: The following example shows a decimal number converted to an integer:

Decimal number:                  Results when assigned to an integer column
                                  or host variable:
2000004.5                        2000004
200000555.0                      200000555