Using the downloaded command-line tool for 3.2.5, I get the same :.0 result. Using an older version which I compiled, I get 9.9, though it seems it should round up to 10.0?
Bob Envision Information Technologies Associate [EMAIL PROTECTED] v. 608.256.5680 f. 608.256.3780 -----Original Message----- From: Eric Bohlman [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 30, 2005 11:05 AM To: [email protected] Subject: Re: [sqlite] Unlucky number for the ROUND function 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).
