Prevent Rounding when using Format Masking [message #671125] |
Thu, 16 August 2018 00:04 |
|
abhi_orcl
Messages: 40 Registered: December 2016
|
Member |
|
|
Hello All,
I have a procedure in which I am doing come calculations. Now, the results return 9.990991768765.
I need to format this to with precision and scale as 18,3. Also, as per the requirement, need to add 0 after the decimals to always show 3 places after decimal. So I use, to_char('9.990991768765','FM999999999999999.000').
But, Oracle always rounds off and fives me 9.991 instead of the desired 9.990
Is there a way I can stop the rounding.
Thanks
|
|
|