Hui folks,
I need to be able to store numbers like 3.5 in my table. So I've used the decimal type field. But if I enter 3.5 it round it up to 4. Am I being stupid or is it not the point of decimal to have a decimal point?
Thanks,
Jonesy
A:
Why you do not use FLOAT,
And if You need to round always numbers to 0.0 or 0.5 take look at this thread
adopilot
2010-04-06 08:30:37
yup that worked, I just though FLOAT was for massive numbers. Thinks I need to get my head around data types again. thanks adopilot!
iamjonesy
2010-04-06 08:34:36
@Jonesy - just make sure you understand the difference between FLOATs and DECIMALs as they are not the same. FLOAT is approximate: http://msdn.microsoft.com/en-us/library/ms173773.aspx vs DECIMAL reference: http://msdn.microsoft.com/en-us/library/ms187746.aspx
AdaTheDev
2010-04-06 08:39:28
Float is a very bad idea if you plan to do math onthe value. It will cause rounding errors as it is not an exact value. Very bad recommendation.
HLGEM
2010-04-06 14:06:59
A:
how you defined decimal? you need to declare it like decimal(18,3) - and 3 means number of digits after point
Sergey Osypchuk
2010-04-06 08:33:21
How did you put data?Maybe you are using stored procedure - than parameter also should have type decimal(18,3), not just decimal.
Sergey Osypchuk
2010-04-06 08:57:29