Please the great god solve a sum sum of strange questions-CodePudding

After the first sum of result is
The date data
20190901 2.8570087 e7
20190902 3.6029693 e7
20190903 3.6786518 e7

Then I added a CONVERT (sum (NUM_CDRS), a DECIMAL (12, 0))

20190901, 4413,
20190902, 36025169,
20190903, 4930,

Then I added a CONVERT (sum (NUM_CDRS), CHAR)
20190901, 4413,
20190902, 36025169,
20190903, 4930,

Then I added a CONVERT (sum (NUM_CDRS), SIGNED)
20190901, 4413,
20190902, 36025169,
20190903, 4930,

In 20190901 the corresponding quantity should be 28570087
Which is the first result is correct, just use the scientific notation, great god, help to solve this problem,

CodePudding user response:

NUM_CDRS bigint (12)