Re: [sqlite] Unlucky number for the ROUND function

[Eric Bohlman]

Edzard Pasma wrote:

I found a number where the ROUND () function goes wrong:

SQLite version 3.2.5
Enter ".help" for instructions
sqlite> select round (9.95, 1);

:.0

I get 9.9 (running on Win98, compiled with MingW).