Home » SQL & PL/SQL » SQL & PL/SQL » Prevent Rounding when using Format Masking (Oracle 12.1.0.2.0, RHEL)
Prevent Rounding when using Format Masking [message #671125] Thu, 16 August 2018 00:04 Go to previous message
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
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Extracting just text from a Blob Column
Next Topic: Row Movement disabled in Partitioned table
Goto Forum:
  


Current Time: Fri Mar 29 00:26:18 CDT 2024