Why is SELECT MIN(CAST(`field` as SIGNED)) rounding my result value?

Question

When I try to use this query

SELECT MIN(CAST(`field` as SIGNED))

The results end up being rounded. So instead of 7.56 that I should be getting I am getting 7. Any ideas?

Answer 1

...CAST(value as DECIMAL(10,5))

Answer 2

because you are using SIGNED, try DECIMAL

SELECT MIN(CAST(`field` as DECIMAL(10,4)))

• SQLFiddle Demo