Re: [sqlite] Mistake in documentation and question

[Richard Hipp]

On Mon, Aug 9, 2010 at 8:38 AM, Ioannis Epaminonda 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

[sqlite] Mistake in documentation and question

[Ioannis Epaminonda]

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 ?

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