# How to get two digit decimal point in double

sri ramvaithiyanathan
Ranch Hand
Posts: 109
Hi,

I used numberformat to get two digit decimal. (Note its return type is string)
In database I need to save this value as double.

So I converted string to double. while converting I am getting decimal value as one digit instead of two.
Is there any way to get two digit decimal point in double.

Output:

P.S: I am facing this problem only when the input is of type x.00

Regards,
Sriram.V

Henry Wong
author
Marshal
Posts: 21719
85
sri ramvaithiyanathan wrote:Hi,

I used numberformat to get two digit decimal. (Note its return type is string)
In database I need to save this value as double.

So I converted string to double. while converting I am getting decimal value as one digit instead of two.
Is there any way to get two digit decimal point in double.

Output:

P.S: I am facing this problem only when the input is of type x.00

Regards,
Sriram.V

There is no such a thing as a format regarding double values -- there is no one digit or two digit. The reason it is showing up as one digit is that the println() is converting it back to a string prior to printing it -- so if you want two digits, convert it back to a string (yourself instead of having the core library do it) and print that string instead.

Henry

Randall Twede
Ranch Hand
Posts: 4489
3

Campbell Ritchie
Sheriff
Posts: 50666
83
If you need to retain the number of places after the decimal point, and you are dealing with a number which you might do arithmetic on, consider aBigDecimal. Beware:new BigDecimal(1.23) does not contain 1.23. It contains something which differs slightly from 1.23. New BigDecimal("1.23") contains exactly 1.23. You can set the scale or round a BigDecimal.
If you are using BigDecimal in Java™, you will probably want a DECIMAL(??, 2) as your type in the database.

Campbell Ritchie
Sheriff
Posts: 50666
83
Have you been taking lessons from Rob Spoor, Randall Twede?

Randall Twede
Ranch Hand
Posts: 4489
3
lol Campbell. no, i have just been using BigDecimal and BigInteger(even more) lately

Rob Spoor
Sheriff
Posts: 20707
68
Campbell meant you beating him in your timing. I tend to do that sometimes, especially to Campbell

Campbell Ritchie
Sheriff
Posts: 50666
83
You are doing well; 45 seconds’ difference, but Rob usually manages 30 seconds

sri ramvaithiyanathan
Ranch Hand
Posts: 109
Thanks to all.

Regards,
Sriram.V

Campbell Ritchie
Sheriff
Posts: 50666
83
You’re welcome