I second that documentation confusion. There is no truncate to integer, though I wish it would.
On 5/27/10, Wilson, Ronald <rwils...@harris.com> wrote: > From http://www.sqlite.org/lang_corefunc.html > > "The round(X,Y) function returns a string representation of the > floating-point value X rounded to Y digits to the right of the decimal > point. If the Y argument is omitted, the X value is truncated to an > integer." > > The documentation above is incorrect in the last clause. The X value is not > truncated it is rounded to an integer. Also, it returns a real, not an > integer or a string. > > SQLite version 3.6.22 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> select round(1.6); > 2.0 > sqlite> select a, typeof(a) from (select round(1.6) as a); > 2.0|real > sqlite> select a, typeof(a) from (select round("1.6") as a); > 2.0|real > sqlite> select a, typeof(a) from (select round('1.6') as a); > 2.0|real > sqlite> > > Ron Wilson, Engineering Project Lead > (o) 434.455.6453, (m) 434.851.1612, www.harris.com > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users