Re: [sqlite] calculating in the command line interface

2014-10-01 Thread jose isaias cabrera
"Igor Tandetnik" wrote... On 10/1/2014 10:34 AM, Stephan Beal wrote: You're doing integer math. You need floating point: select round(1/2,10) as t; You probably meant round(1.0/2, 10), or round(1/2.0, 10) or similar. Thanks, Igor. ___

Re: [sqlite] calculating in the command line interface

2014-10-01 Thread jose isaias cabrera
"Stephan Beal" wrote... On Wed, Oct 1, 2014 at 4:34 PM, Stephan Beal wrote: You're doing integer math. You need floating point: select round(1/2,10) as t; 0.5 And this time with the right copy/paste buffer: sqlite> select round(1.0/2,10) as t; 0.5 I was going to

Re: [sqlite] calculating in the command line interface

2014-10-01 Thread John Hascall
​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*

Re: [sqlite] calculating in the command line interface

2014-10-01 Thread Stephan Beal
On Wed, Oct 1, 2014 at 4:34 PM, Stephan Beal wrote: > You're doing integer math. You need floating point: > > select round(1/2,10) as t; > 0.5 > And this time with the right copy/paste buffer: sqlite> select round(1.0/2,10) as t; 0.5 -- - stephan beal

Re: [sqlite] calculating in the command line interface

2014-10-01 Thread Igor Tandetnik
On 10/1/2014 10:34 AM, Stephan Beal wrote: You're doing integer math. You need floating point: select round(1/2,10) as t; You probably meant round(1.0/2, 10), or round(1/2.0, 10) or similar. -- Igor Tandetnik ___ sqlite-users mailing list

Re: [sqlite] calculating in the command line interface

2014-10-01 Thread Stephan Beal
On Wed, Oct 1, 2014 at 4:27 PM, jose isaias cabrera 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

[sqlite] calculating in the command line interface

2014-10-01 Thread jose isaias cabrera
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, h, let me try this, select