How transform the return value of the round to a non-prefix and non-suffix string?

zhouhaiming · #1 (**permalink**) 09-22-06, 10:37

Hello, everyone
1.
$ db2 "select char(round(3234.235, 5)) from sysibm.sysdummy1"

1
----------
03234.235

1 record(s) selected.

2.
1
----------------
013435.56464000

1 record(s) selected.

3.
$ db2 "select char(round(1233435.56463621, 5)) from sysibm.sysdummy1"

1
------------------
01233435.56464000

1 record(s) selected.

But I want to get the following value
3234.235
13435.56464
1233435.56464

sathyaram_s · #2 (**permalink**) 09-22-06, 12:19

Try this ..

values(replace(ltrim(rtrim(replace('01233005.56464 000','0',' '))),' ','0'))

I hope there is a simpler method

rahul_s80 · #3 (**permalink**) 09-22-06, 12:45

i dont understand why u r using char

C:\Program Files\IBM\SQLLIB\BIN>db2 values (round(1233435.56463621, 5))

1
------------------
1233435.56464000

zhouhaiming · #4 (**permalink**) 09-22-06, 20:14

Thank you for your help! sathyaram_s is right!!
I am doing a project that migrate the stored procedure and function from Oracle to DB2. I found many difference between them!

Internet Services

Web Development

Digital Marketing

Consumer Tech