On 6/10/07, Olaf Schmidt <[EMAIL PROTECTED]> wrote:

Hi drh,

> http://www.sqlite.org/faq.html#q18

Not so easy I think (I'm well aware of rounding-problems
regarding the IEEE-Float-Formats, etc.).

Bankers rounding aside at the moment.

select round(0.95, 1)

0.9

select round(9.95, 1)

9.9

select round(0.995, 2)

0.99

select round(9.995, 2)

9.99


(3.3.17 here)

--
Alberto Simões

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to