title: Vertica: convert integer result to a specific format (eg. from 6.50945378E8 to 650,945,378)
body: <p>This is my query:</p>
  
  <pre><code>select send_date
          , sum(total_requests) as 'All'
          , sum(portion_requests) as 'Subset'
          , (sum(total_requests)-sum(portion_requests)) as 'Delta'
  from f_stats
  where send_date = '2015-01-22'
  group by send_date
  </code></pre>
  
  <p>The "total_requests" and "portion_requests" elements are numbers.  The sum of these numbers is in the hundreds of millions (eg 500,000,000).  My query results are returned in an undesired format.  They look like "6.50945378E8" when I want them to look like "650,945,378".  </p>
  
  <p>How do I force the formatting?</p>