>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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
