A SUM with more decimal places than the values being SUMed?

2002-11-25 Thread Andrew Kuebler
I'm running a query to SUM a Decimal field with the configuration of DECIMAL(6,2) and I get a result looking like: 56.5515009 How is this possible??? Thank you in advance... Andrew - Before posting, please check:

Re: A SUM with more decimal places than the values being SUMed?

2002-11-25 Thread Rodney Broom
From: Andrew Kuebler [EMAIL PROTECTED] I'm running a query to SUM a Decimal field with the configuration of DECIMAL(6,2) and I get a result looking like: 56.5515009 Hi Andrew, I just did this (v 3.23.52): mysql create table dd ( myfloat decimal(6,2)) mysql insert into dd