Forum Discussion
Hi Matthew,
Checked the combination of type possible for this field is below.
6,515,871,900,000
6,515,871,900,000
6,515,871,900,000
6,515,871,900,000
6,515,871,900,000
6,515,871,900,000
256,800,000,000
256,800,000,000
256,800,000,000
87,351,502,445.84
76,476,000,000
64,290,705,800.14
0.00
0.00
Null
Null
Do you have any idea which data type will suite for the table creation? Please help.
Regards,
Amar.
- mbowen4 years agoEmployee
DOUBLE PRECISION if we care about decimals. I see only two values (.84 and .14). If those can be stored as integers, then BIGINT. If BIGINT, we need to handle the decimal values in the pipeline by either rounding or truncating decimal values.
Oh, I also notice 0.00 and the .00 may be significant. DOUBLE PRECISION would be able to store all of these representations.