Silvia Mello
New User
Joined: 19 Jan 2009 Posts: 1 Location: Brazil
|
|
|
|
Hi there,
Please, I need some help.
I'm using SPUFI and I'm trying to Select a column that is Float. I need to see the value in Decimal format. I'm not sure which scalar function I could use. I've tried DEC but I noticed that it's truncating the result:
---------+---------+---------+---------+---------+---------+
CREATE TABLE A151673.TESTE_FLOAT
(COL01 FLOAT(23));
---------+---------+---------+---------+---------+---------+
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0
---------+---------+---------+---------+---------+---------+
INSERT INTO A151673.TESTE_FLOAT
VALUES (1234567890123456789);
---------+---------+---------+---------+---------+---------+
DSNE615I NUMBER OF ROWS AFFECTED IS 1
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0
---------+---------+---------+---------+---------+---------+
SELECT DECIMAL(COL01, 19) , COL01
FROM A151673.TESTE_FLOAT;
---------+---------+---------+---------+---------+---------+
COL01
---------+---------+---------+---------+---------+---------+
1234567890123460000, +0,1234567890123457E+19
DSNE610I NUMBER OF ROWS DISPLAYED IS 1
Noticed that although the number I've inserted was 1234567890123456789, the number displayed was 1234567890123460000.
Does anyone know how to solve this problem?
Thanks in advance! |
|