DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: number format

  1. #1
    Join Date
    Jan 2001
    When I query for a sum of a column I am getting the following:
    How do I get this to come out as $1,105,200.00......?

  2. #2
    Join Date
    Feb 2001
    Paris, France
    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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.