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 integer)); typeof(cast(round(3.14) as integer)) ------------------------------------ integer sqlite> Jim On 3/18/09, sqlite.20.ede...@spamgourmet.com <sqlite.20.ede...@spamgourmet.com> wrote: > 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 > -- Software first. Software lasts! _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users