Re: Rounding off the scale value after decimal point

Perl will use the floating point library for the C compiler used to build it, so I would expect (but not guarantee) that a C interface to the database would give the same answer as the perl interface.

Double precision only has 15 or 16 significant digits, so the "4" in the right-most place is almost certainly not significant. See, for example,http://www.monash.edu.au/policy/gpnumacc.htm#SignificantFigures.

Information about American English usage here and here. Floating point issues? Please read this before posting. — emc

Comment on Re: Rounding off the scale value after decimal point

Replies are listed 'Best First'.
Re^2: Rounding off the scale value after decimal point by venu_hs (Novice) on Sep 21, 2012 at 08:27 UTC
Thank you monks for your responses. I dont want to round off the number. So i started using bignum module to specify the precision as 17. So if a number is actually 500.123, as per the precision of 17, it becomes 500.12300000000000000 which is ideal and intended. But then i would need it as 500.123 Any other perl modules i can use to accomodate this scenario.	[reply]
Re^3: Rounding off the scale value after decimal point by Anonymous Monk on Sep 21, 2012 at 22:19 UTC
But then i would need it as 500.123 Any other perl modules i can use to accomodate this scenario. How odd, either you want the precision or you don't	[reply]
Re^3: Rounding off the scale value after decimal point by Anonymous Monk on Sep 22, 2012 at 09:06 UTC
You can squash trailing zeros with `$num =~ s/0+$//;`	[reply] [d/l]