decimal vs double! - Which one should I use and when?

Posted by Soni Ali on Stack Overflow See other posts from Stack Overflow or by Soni Ali
Published on 2009-07-22T14:37:54Z Indexed on 2010/05/07 10:28 UTC
Read the original article Hit count: 357

Filed under:

decimal

|

double

|

money

|

c#

I keep seeing poeple using doubles in C#. I know I read somewhere that double sometimes loose precision. My question is when should a use a double and when should I use a decimal type? which type is suitable for money computations? (ie. greater than $100 million)

© Stack Overflow or respective owner

Related posts about decimal

Convert string value into decimal with proper decimal points

as seen on Stack Overflow - Search for 'Stack Overflow'
i have value stored in string format & i want to convert into decimal. ex: i have 11.10 stored in string format when i try to convert into decimal it give me 11.1 instead of 11.10 . I tried it by following way string getnumber="11.10"; decimal decinum=Convert.ToDecimal(getnumber); i tried… >>> More
Trouble with a query

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi there, I'm having trouble with a query in SQL Server 2008 on some forex trading data. I have a trades table and an orders table. A trade needs to comprise of 2 or more orders. DDL schema and sample data below. What I want to do is write a query that shows the profit/loss in pips for each trade… >>> More
Rounding down DECIMAL(14,3) to thrid decimal digit in SQL 2008

as seen on Stack Overflow - Search for 'Stack Overflow'
I have to round down all incoming data with type DECIMAL(14,3) which has 3 decimal digit to the last one. I.e.: 100; 100.0; 100.00; 100.000 -> 100 100.2; 100.02; 100.20; 100.22 -> 100.xx but 100.221 -> 100.22 100.229 -> 100.22 Using which SQL operator can I check that residue of… >>> More
Double.TryParse() input decimal separator different than system decimal separator

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a source XML that uses a dot (".") as a decimal separator and I am parsing this on a system that uses a comma (",") as a decimal separator. As a result, value of 0.7 gets parsed with Double.TryParse or Double.Parse as 7000000. What are my options to parse correctly? One of them is to replace… >>> More
Rounding down DECIMAL(14,3) to third decimal digit in SQL 2008

as seen on Stack Overflow - Search for 'Stack Overflow'
I have to round down all incoming data with type DECIMAL(14,3) which has 3 decimal digit to the last one. I.e.: 100; 100.0; 100.00; 100.000 -> 100 100.2; 100.02; 100.20; 100.22 -> 100.xx but 100.221 -> 100.22 100.229 -> 100.22 Using which SQL operator can I check that residue of… >>> More

Related posts about double

Using delegates in C# (Part 2)

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Part 1 of this post can be read here. We are now about to see the different syntaxes for invoking a delegate and some c# syntactic sugar which allows you to code faster. We have the following console application. 1: public delegate double Operation(double x, double y); 2: 3: public… >>> More
How to rotate a set of points on z = 0 plane in 3-D, preserving pairwise distances?

as seen on Game Development - Search for 'Game Development'
I have a set of points double n[] on the plane z = 0. And I have another set of points double[] m on the plane ax + by + cz + d = 0. Length of n is equal to length of m. Also, euclidean distance between n[i] and n[j] is equal to euclidean distance between m[i] and m[j]. I want to rotate n[] in 3-D… >>> More
dividing double by double gives weird results - Java

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am trying to do the following 33.33333333333333/100.0 to get 0.333333333333333 however when I run System.out.println(33.33333333333333/100.0); I get 0.33333333333333326 as the output, similarly when I run System.out.println(33.33333333333333/1000.0); I get 0.033333333333333326 as the output… >>> More
C# (4): double minus double giving precision problems

as seen on Stack Overflow - Search for 'Stack Overflow'
I have come across a precision issue with double in .NET I thought this only applied to floats but now I see that double is a float. double test = 278.97 - 90.46; Debug.WriteLine(test) //188.51000000000005 //correct answer is 188.51 What is the correct way to handle this? Round? Lop off the unneeded… >>> More
Is there a Math.atan2 substitute for j2ME? Blackberry development

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a wide variety of locations stored in my persistent object that contain latitudes and longitudes in double(43.7389, 7.42577) format. I need to be able to grab the user's latitude and longitude and select all items within, say 1 mile. Walking distance. I have done this in PHP so I snagged my… >>> More