print "+" when using to_char [message #683492] |
Sun, 24 January 2021 12:23 |
|
robh0502
Messages: 5 Registered: January 2015 Location: Phoenix, AZ
|
Junior Member |
|
|
Hi,
Looking for a way to format a number by showing 0's to the left and right of the decimal. Also, looking to print a plus sign. There should be 6 digits in the front and 6 in the back of the decimal. For example,
654.89 should be displayed as +000654.890000
I've come up with the following
replace(to_char(654.89, '000000.000000'), ' ', '+')
Does anyone have a way to showing the plus sign without using replace?
|
|
|
|
|
|