2.8.15 gives 9.9 --Keith
On 8/30/05, Bob Dankert <[EMAIL PROTECTED]> wrote: > > 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). >
