I ran into the same problem but in a case where I do not have control of the output to string, which was taken care of by a library. After looking into details in the implementation of the Decimal type (see http://msdn.microsoft.com/en-us/library/system.decimal.getbits.aspx), I came up with a neat trick (here as an extension method): public … Read more
Use the P format string. This will vary by culture: String.Format(“Value: {0:P2}.”, 0.8526) // formats as 85.26 % (varies by culture)
Use Convert.ToInt32 from mscorlib as in decimal value = 3.14m; int n = Convert.ToInt32(value); See MSDN. You can also use Decimal.ToInt32. Again, see MSDN. Finally, you can do a direct cast as in decimal value = 3.14m; int n = (int) value; which uses the explicit cast operator. See MSDN.
If you just want to round the number for output purposes, then the “%.2f” format string is indeed the correct answer. However, if you actually want to round the floating point value for further computation, something like the following works: #include <math.h> float val = 37.777779; float rounded_down = floorf(val * 100) / 100; /* … Read more
You can pass the format in to the ToString method, e.g.: myFloatVariable.ToString(“0.00”); //2dp Number myFloatVariable.ToString(“n2”); // 2dp Number myFloatVariable.ToString(“c2”); // 2dp currency Standard Number Format Strings
The answer from Dave Van den Eynde is now out of date. There are 2 important changes, from EF 4.1 onwards the ModelBuilder class is now DbModelBuilder and there is now a DecimalPropertyConfiguration.HasPrecision Method which has a signature of: public DecimalPropertyConfiguration HasPrecision( byte precision, byte scale ) where precision is the total number of digits … Read more
I think you’ve summarised the advantages quite well. You are however missing one point. The decimal type is only more accurate at representing base 10 numbers (e.g. those used in currency/financial calculations). In general, the double type is going to offer at least as great precision (someone correct me if I’m wrong) and definitely greater … Read more
Try this code: String str = “a12.334tyz.78x”; str = str.replaceAll(“[^\\d.]”, “”); Now str will contain “12.334.78”.
Numeric precision refers to the maximum number of digits that are present in the number. ie 1234567.89 has a precision of 9 Numeric scale refers to the maximum number of decimal places ie 123456.789 has a scale of 3 Thus the maximum allowed value for decimal(5,2) is 999.99
DECIMAL(18,0) will allow 0 digits after the decimal point. Use something like DECIMAL(18,4) instead that should do just fine! That gives you a total of 18 digits, 4 of which after the decimal point (and 14 before the decimal point).