title: How to format a Float number in SQLite?
body: <p>In SQLite I need to format a number to display it with the thousand separator and decimal separator. Example: The number <code>123456789</code> should be displayed as <code>1,234,567.89</code></p>
  
  <p>What I did partially works because it does not display the thousand separator as I expected:</p>
  
  <pre><code>select *, printf ("U$%.2f", CAST(unit_val AS FLOAT) / 100) AS u_val FROM items;
  </code></pre>
  
  <p><code>u_val</code> shows: <code>U$1234567.89</code> but I need <code>U$1,234,567.89</code></p>