Post by jos.. » Sun, 31 Dec 1899 09:00:00

Having rounding problem.  AIX 3.2  RISC 6000 informix 4.11
Database netamt decimal(16,4) = 7.475
when I equate this field to another field defined as decimal or
decimal(16) the new value is 7.48, however in other circumstances the
last digit may be truncated?  Help!!




1. Round 0.5 is rounded down instead of UP!!!

Hi there...

If I use the SQL ROUND(numeric_expression, length) function in my queries,
this happens:

    ROUND(0.4 ,1) --> 0
    ROUND(0.5 ,1) --> 0
    ROUND(0.6 ,1) --> 1

WHY!!! is 0.5 rounded down, and how can I change this!!!

Could this be a diff. between european and US standards??

Please help...



2. ODBC Oracle-Access

3. ROUND not accurating rounding/truncating

4. NEWBIE needs help creating table

5. Round 0.5 is rounded down instead of UP!!!

6. Another Good SQL Source

7. Round-and-round with passwords

8. [Fwd: Searching!!]

9. Rounding - how to do "Bankers Rounding" in SQL Server 2000

10. round money

11. Rounding datetime in SQL Server

12. Rounding off a Time

13. Division seems to truncate rather than round