Java best type to hold price

Question

Possible Duplicate:
Representing Monetary Values in Java

which java type is good to handle price value? and please tell my why ?

I dont know it is simply question :)

I only know that this type must be "safe". Because if we create shop applicatoion or somethink like that.

ps. I need BEST PRACTICE

and how it present in database ?

related https://stackoverflow.com/questions/588004/is-floating-point-math-broken — Ahmed Nabil, Jun 06 '23 at 12:14

score 27 · Answer 1 · answered Sep 19 '12 at 14:12

you should use BigDecimal when dealing with currencies. Java's native floating point types suffer from the same precision issues as other languages, since some decimals cannot be accurately represented as floating point numbers. Even thought it's not java specific, this is an excellent article which describes the complexities around representing decimal values as floating point numbers.

In general, transient values in your application should always use BigDecimal, only converting to a float when you must (for persistence, or displaying data to a user, etc).

score 7 · Answer 2 · answered Sep 19 '12 at 14:14

7

an integer (or long) for the smallest denomenator you care about (cents for USD and EUR)

this is because floating points on computers are inherently inaccurate for decimal values(0.1+0.2 != 0.3)

you only need to translate between cent and main dollar in the UI while the domain calculates everything in cents

answered Sep 19 '12 at 14:14

ratchet freak

47,288
5
68
106

`long` is the best, as long as you fit in. Which shouldn't be a problem, most of the times. – zeller Sep 19 '12 at 14:16
1

@zeller Unless you have insane hyper-inflation, in which case I would avoid those currencies. – Peter Lawrey Sep 19 '12 at 14:19

score 4 · Answer 3 · answered Sep 19 '12 at 14:14

Personally, I would use BigDecimal (and so does my company!). I consider float or double bad suggestions because of the way floating-point values are stored in the system and there is a possibility of loss of precision (which you certainly don't want when handling money).

score 3 · Answer 4 · answered Sep 19 '12 at 14:17

3

If you're building a financial system, I recommend you create or use your own Java class to represent monetary amounts.

As far as the data type to use to hold a monetary amount, long or BigDecimal.

Here's an example Money class that shows the types of methods you need when working with monetary amounts.

answered Sep 19 '12 at 14:17

Gilbert Le Blanc

50,182
6
67
111

2

And SQL representation of this class? – Łukasz Woźniczka Sep 19 '12 at 14:28

score 1 · Answer 5 · answered Sep 19 '12 at 14:18

1

If you use sensible rounding of your results double is works perfectly well and not only the fastest but the simplest to write. This can represent money up to $70 trillion without error. Don't use float as this can only represent up to about $10,000 without error.

If you don't know what sensible rounding to use, BigDecimal or long cents could be a better choice.

answered Sep 19 '12 at 14:18

Peter Lawrey

525,659
79
751
1,130

What would sensible rounding be in this case? – lovrodoe Oct 22 '19 at 12:09
@lovrodoe if you really don't know then 8 decimal places is probably ok. – Peter Lawrey Nov 05 '19 at 18:41

score 0 · Answer 6 · answered Sep 19 '12 at 14:13

0

You need to use the BigDecimal class.

answered Sep 19 '12 at 14:13

Alex

25,147
6
59
55

Java best type to hold price

6 Answers6

Linked