>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