how to rounding the numbers after decimal point?

Question

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

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

score 0 · Answer 1 · answered Mar 15 '12 at 04:38

0

how about this in sql server.

SELECT round (cast(23.645464 AS DECIMAL(10,1)),2);

answered Mar 15 '12 at 04:38

Vishwanath Dalvi

35,388
41
123
155

score 0 · Answer 2 · edited Dec 09 '13 at 17:34

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;
  }

edited Dec 09 '13 at 17:34

BenMorel

34,448
50
182
322

answered Mar 15 '12 at 04:39

Nirav Valera

420
4
13

how to rounding the numbers after decimal point?

2 Answers2