Hi Am developing one application in java and Am using sql server database . I'm inserting values in database in 23.6 but its appending like 23.645464 . is there any method to append after decimal no only one digit. please help me.
Thanks
Asked
Active
Viewed 472 times
0
-
Try editing the table structure so that the target field only holds one decimal place. – Telmo Marques Mar 15 '12 at 04:39
-
Possible duplicate: http://stackoverflow.com/questions/1005725/save-float-values-in-sql-server – Renato Mar 15 '12 at 04:40
-
check this http://stackoverflow.com/questions/153724/how-to-round-a-number-to-n-decimal-places-in-java – Darshana Mar 15 '12 at 04:42
2 Answers
0
how about this in sql server.
SELECT round (cast(23.645464 AS DECIMAL(10,1)),2);
Vishwanath Dalvi
- 35,388
- 41
- 123
- 155
0
Hey you can try this code in Java file before storing value in database..
For example :
Function call :
float round = Round(num,1);
Definition:
public static float Round(float val, int dec) {
float p = (float)Math.pow(10,dec);
val = val * p;
float tmp = Math.round(val);
return (float)tmp/p;
}
BenMorel
- 34,448
- 50
- 182
- 322
Nirav Valera
- 420
- 4
- 13