Pavel,
SQL functions take the format of the first value they see to format a column. To get around this you can
SELECT nMyNumber + 000000.0000 AS nMyNumber, ;
PADR(cMyShortString, 50) AS cMyLongString, ......
>Hi,
>I have a table on Oracle with column number(13,2).
>example:
>_sqlexec("create table bla (bla number(13,2))")
>_sqlexec("insert into bla values (3.14)")
>after
>_sqlexec("select * from bla")
>I've got number 3.14
>but after
>_sqlexec("select sum(bla) from bla")
>I've got number 3
>and
>_sqlexec("select to_char(sum(bla)) from bla")
>return
>char 3.14
>
>Why sum() function rounded values ?
>Pavel Poul
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only