Re: Rounding off the scale value after decimal point

[swampyankee]

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.

[venu_hs]

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.

[Anonymous Monk]

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

[Anonymous Monk]

You can squash trailing zeros with  $num =~ s/0+$//;