Is there a database level setting for rounding decimal?

makonahalli · #1 (**permalink**) 01-05-07, 15:38

DB2 by default truncates the decimal values to the field precision setting. Is there a database level setting to make this round the value rather than truncate?

Thanks for your help.

n_i · #2 (**permalink**) 01-05-07, 17:27

Would the ROUND() function work for you?

makonahalli · #3 (**permalink**) 01-05-07, 19:26

I am aware of the ROUND function, I am looking for a database wide setting. My application is used on multiple databases and hence if I use the ROUND then I have to have database specific code in many places.

So, I am looking for a database wide setting if there is one.

Thanks for your reply.

n_i · #4 (**permalink**) 01-05-07, 20:51

No there is not. Is there such setting in other "mutliple databases"? I doubt that...

Peter.Vanroose · #5 (**permalink**) 01-07-07, 08:07

Quote:

Originally Posted by makonahalli

If I use ROUND() then I have to have database specific code in many places.

So, I am looking for a database wide setting if there is one.

There is an easy way to implement the ROUND function yourself, in a database wide way, and moreover without the overhead of a scalar function call:

1. Round a positive expression (expr) to the nearest integer value:

Code:

CAST(expr + 0.5 AS integer)

(Or just INT(expr + 0.5) .)

2. Round a positive expression (expr) to the nearest multiple of 0.01:

Code:

CAST(expr + 0.005 AS decimal(18, 2))

3. Round any (positive or negative) expression to the nearest integer:

Code:

case when expr > 0 then CAST(expr+0.5 AS int) else CAST(expr-0.5 AS int) end

Internet Services

Web Development

Digital Marketing

Consumer Tech