Hi!

Is this expected?

$ sqlite3
SQLite version 3.6.10
Enter ".help"for instructions
Enter SQL statements terminated with a ";"
sqlite> select round(3.1416);
3.0
CPU Time: user 0.000000 sys 0.000000
sqlite> 

I expected an integer 3 as documented:

round(X)
round(X,Y)      Round off the number X to Y digits to the right of the
decimal point. If the Y argument is omitted, 0 is assumed.

Thanks in advance.

Edésio
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to