"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.
___
sqlite
"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 reply to your original
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*
*sc
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
http://wanderinghorse.net/home/steph
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
sqlite
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 round(1/2,10) as t;
>
> tha
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 round(10/2,
7 matches
Mail list logo
