mrpaulwass
09-26-2002, 03:44 PM
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,990')) FROM dual
results in
-$35,000,000
I would like it on the right.
Thanks,
P