title: Teradata formatting amounts of money
body: <p>I have a problem with formatting, I exports data of the amount of money balances to excel, but I have a bad format. </p>
  
  <pre><code>SELECT COALESCE(TRIM(CAST(ZEROIFNULL(balance) AS DECIMAL(15,2) FORMAT '--Z(15)D9(2)')), 0);    
  </code></pre>
  
  <p>I would like to change the character dot on the comma and when the balance is equal to 0 to display 0,00 because now I have a .00 </p>
  
  <p>Is it possible without changes to VARCHAR ?</p>
  
  <p>Thanks in advance for your help</p>