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] -----------------------------------------------------------------------------