Happy new year all, Have not followed the full thread, in case it has not been mentioned already:
http://dec64.com/ Cheers On Tue, 18 Dec 2018 at 02:42, Keith Medcalf <kmedc...@dessus.com> wrote: > >This thread is getting out of hand. Firstly there is no such binary > >representation ( in this universe ) for a trivial decimal number such > >as one tenth ( 0.10 ) and really folks should refer to the text book > >recently published ( 2nd Edition actually ) where all this is covered > >: > > Handbook of Floating-Point Arithmetic > > Authors: Muller, J.-M., Brunie, N., de Dinechin, F., > > Jeannerod, C.-P., Joldes, M., Lefèvre, V., > > Melquiond, G., Revol, N., Torres, S. > > > > This handbook is a definitive guide to the effective use of > > modern floating-point arithmetic, which has considerably > > evolved, from the frequently inconsistent floating-point number > > systems of early computing to the recent IEEE 754-2008 standard. > > > https://doc.lagout.org/science/0_Computer%20Science/3_Theory/Handbook%20of%20Floating%20Point%20Arithmetic.pdf > > While it is true there is no exact representation of 1/10th in binary > floating point, at double precision the epsilon is 1.3877787807814457e-17 > which means that for all intents and purposes 1/10th is exact to 16.9 > decimal places. Which is pretty damn good for a format that is only > purported to be accurate to 15 decimal digits. > > --- > The fact that there's a Highway to Hell but only a Stairway to Heaven says > a lot about anticipated traffic volume. > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Pavlos Christoforou Point Nine Limited Mobile: +357 99 160960 pavlos.christofo...@p9ft.com _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
