Question on Decimal type
"Bayless Kirtley" <[email protected]> Sun, 23 Jul 2006 18:16:48 -0500
| Newsgroups | gmane.comp.db.mckoi |
|---|---|
| Message-ID | <001501c6aeae$13fd55b0$0a00a8c0@Desktop> |
I have a table with a column defined as DECIMAL(6,2). My program calculates a percentage as 6.875 then stores the result in the above referenced field. When I retrieve that value, it comes back as 6.875 where I expected it to be 6.88 or possible 6.87. Is this an error or have I just misunderstood how the data base should store a decimal value? Thanks in advance. Bayless Kirtley