Forum Discussion

GeorgePandiaraj's avatar
GeorgePandiaraj
12 years ago

SQL query involving decimal number columns

Issue: When I execute a SQL query that uses decimal value, SmartBear treats them as whole numbers when they are computed. 1. I have a test that will execute a SQL query on Tandem Non-Stop system ...
nmrao's avatar
nmrao
Champion Level 3
12 years ago
Tried on oracle database which is seems to be absolutely fine.

Query:
select to_char(to_number('11.199', '99.999') + to_number('12.119', '99.999'), '99.999') from dual

<Results>
    <ResultSet fetchSize="10">
        <Row rowNumber="1">
            <TO_CHARTO_NUMBER11.19999.999TO_NUMBER12.11999.99999.999> 23.318</TO_CHARTO_NUMBER11.19999.999TO_NUMBER12.11999.99999.999>
        </Row>
    </ResultSet>
</Results>


No idea about Tandem