On Mon, Aug 9, 2010 at 8:38 AM, Ioannis Epaminonda <ioanni...@gmail.com>wrote:

>
> In page http://www.sqlite.org/datatype3.html
> under section 3.2 Affinity Of Comparison Operands 2nd bullet point should
> read:
> An expression .... "CAST(expr AS type)" .... instead of "CAST(expr TO
> type)"
>
> In addition a quick question.
> Is there a way to perform a division of two columns (real type) and force
> the result to be presented/rounded in 2 decimal places ?
>

round(a/b, 2)


>
> Thanks
> --
> View this message in context:
> http://old.nabble.com/Mistake-in-documentation-and-question-tp29387429p29387429.html
> Sent from the SQLite mailing list archive at Nabble.com.
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to