"Stephan Beal" wrote...
On Wed, Oct 1, 2014 at 4:34 PM, Stephan Beal <sgb...@googlemail.com>
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 email and ask what version were you
using.;-) Yes, this one works. And thank you all that responded.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users