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 -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom is sloppy. But since tyranny's the only guaranteed byproduct of those who insist on a perfect world, freedom will have to do." -- Bigby Wolf _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users