Thaks for the workaround.
But according to the documentation, round(3.1416) should return zero digits
to the right of the decimal point. I checked with mysql:
$ mysql
Server version: 5.0.51a-3ubuntu5.4 (Ubuntu)
mysql> select round(3.1416);
+---+
| round(3.1416) |
+---+
|
Well, it doesn't exactly say that an integer is returned. round()
always returns a float:
sqlite> select typeof(3);
typeof(3)
--
integer
sqlite> select typeof(round(3));
typeof(round(3))
real
sqlite>
You can do this:
sqlite> select typeof(cast(round(3.14) as
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.00 sys 0.00
sqlite>
I expected an integer 3 as documented:
round(X)
round(X,Y) Round off the number X
3 matches
Mail list logo