A NUMERIC or DECIMAL datatype with scale 0 can be converted into a SIGNED INTEGER, provided the precision required to represent the maximum value of the integer is greater than or equal to the precision of the NUMERIC or DECIMAL datatype.
NUMERIC or DECIMAL datatypes with a scale other than zero cannot be converted to an integer, and numerics cannot be converted into unsigned integers.
A NUMERIC or DECIMAL datatype can be converted to other numeric or decimal types, provided that the scale of the target type is greater than or equal to the scale of the source numeric, and the precision of the target numeric is greater than or equal to the precision of the source numeric plus the difference between the target scale and the source scale.
NUMERIC(4, 2) can be converted into a NUMERIC(4, 4) NUMERIC(2, 2) can be converted into a NUMERIC(4, 4) NUMERIC(2, 4) cannot be converted into a NUMERIC(4, 0) NUMERIC(2, 4) cannot be converted into a NUMERIC(3, 6)
