-
When I query for a sum of a column I am getting the following:
1.1052E+11
How do I get this to come out as $1,105,200.00......?
-
there are 2 points
1) getting the whole number (not ...E+..) is done by changing the value of the numwidth parameter (set numwidth 20)
2) getting the $, '.', and ',' is done with to_char :
select to_char (column,'$999G999G999D00)
from table;
(with enough 999 of course)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|