Is there a way using to_char to move the negative sign to the right?
SELECT trim(to_char(-35000000,'$999,999,990')) FROM dual
results in
-$35,000,000
I would like it on the right.
Thanks,
P
Printable View
Is there a way using to_char to move the negative sign to the right?
SELECT trim(to_char(-35000000,'$999,999,990')) FROM dual
results in
-$35,000,000
I would like it on the right.
Thanks,
P
SELECT trim(to_char(-35000000,'$999,999,990MI')) FROM dual
Thank you very much :o)