Developers have problems using default round function so it is somethink
we need.
So I have:
ROUTINES FOR ROUNDING IEEE-754 FLOATS TO SPECIFIED NUMBER OF DECIMAL
FRACTIONS
These routines round input values to fit as closely as possible to an
output number with desired number of decimal fraction digits.
Because, in general, numbers with decimal fractions cannot be exactly
represented in IEEE-754 floating binary point variables, error limits
are used to determine if the input numbers are intended to represent an
exact decimal fraction rather than a nearby value. Thus an error limit
will be taken into account when deciding that a number input such as
1.295, which internally is represented 1.29499 99999 …, really should
be considered exactly 1.295 and that 0.29999 99999 ... really should
be interpreted as 0.3 when applying the rounding rules.
I just provided 2 functions. But I have many options like (copy from code):
(Abbr: 'HalfEven'; Dscr: 'Round to nearest or to even whole number '
'(a.k.a Bankers) '),
(Abbr: 'HalfPos' ; Dscr: 'Round to nearest or toward positive'),
(Abbr: 'HalfNeg' ; Dscr: 'Round to nearest or toward negative'),
(Abbr: 'HalfDown'; Dscr: 'Round to nearest or toward zero'),
(Abbr: 'HalfUp' ; Dscr: 'Round to nearest or away from zero'),
(Abbr: 'RndNeg' ; Dscr: 'Round toward negative. (a.k.a. Floor) '),
(Abbr: 'RndPos' ; Dscr: 'Round toward positive. (a.k.a. Ceil ) '),
(Abbr: 'RndDown' ; Dscr: 'Round toward zero. (a.k.a. Trunc) '),
(Abbr: 'RndUp' ; Dscr: 'Round away from zero.') );
Radovan
On 24.05.2019 14:34, Simon Slavin wrote:
On 24 May 2019, at 1:30pm, Jose Isaias Cabrera <jic...@outlook.com> wrote:
Dr. Hipp, how many more scenarios, where round gives the wrong answer, exist?
Thanks.
As Dr. Hipp wrote, round was giving the right answer. All you need to do is
pass the number 3.255 as the parameter. If you're passing the wrong number,
don't blame SQLite for getting the wrong result.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users