Wednesday, August 10, 2022

[FIXED] Why does Double return the wrong data from my DB?

Issue

I have a number in my database 2250.67

I fetch it this way

Double doubleBalance = (double) getBalance();

and this is what it outputs 2250.0

shouldn't it output 2250.67

What could I be doing wrong?


Solution

Since you said

I have a number in my database 2250.67

I'm assuming datatype for the said dB field is decimal

Check if, while fetching the data you have right datatype set in the application code.



Answered By - tausif
Answer Checked By - Gilberto Lyons (PHPFixing Admin)

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.