You got bit by integer division...
asw-1# {773} *sqlite3*
SQLite version 3.7.5
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> *select round(133.0/122000.0,10) as t;*
0.0010901639
sqlite>
BTW, there are other tools for simple math...
asw-1# {772} *bc -l*
*scale=10133/122000*
.0010901639
On Wed, Oct 1, 2014 at 9:27 AM, jose isaias cabrera <jic...@cinops.xerox.com
> wrote:
>
> So, I needed to get a really low percentage and I went to the SQlite3
> command prompt and I typed,
>
> select round(133/122000,10) as t;
>
> that gave me 0.0. Then, I said, ok, let's try this,
>
> select round(1/2,10) as t;
>
> that also gave me 0.0. Then I said, hmmmm, let me try this,
>
> select round(10/2,10) and that gave me 5.0, which is what I expect. Is
> there a way that I can calculate some fractional numbers in the sqlite3
> command line? I am using v3.8.6. Thanks.
>
> josé
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
