On 24 May 2019, at 13:35, Jose Isaias Cabrera <jic...@outlook.com> wrote:
> Alessandro Merolli, on Friday, May 24, 2019 07:39 AM, wrote... > >> Great! Now use SQLite API and add a new user defined function for >> your used case. >> I suppose that SQlite should always follow a well-defined pattern: in >> this case as Mr. Hipp said, it is IEEE754. > > If IEEE754 can't figure out how to round 3.555 to 2 decimals, I don't know if > I'd trust it. ;-) thanks. IEEE754 knows nothing about 3.555. If you input that, it gets changed to a binary floating point number with a different actual value. Which is then rounded. No point in complaining about that. -- Cheers -- Tim _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users