title: How to set 2 decimal places in sqlite select statement
body: <p>I have a sqlite table that has amount field with NUMERIC(10,5) value(I know data type meant not much in sqlite). I want to write a select statement that display amount in 2 decimal places. </p>
  
  <pre><code>    id      name             type        notnull      dflt_value      pk   
  ------- --------------- ---------- ----------- -------------- --- 
  0        _id              integer       0                            1    
  1        name             varchar       1                            0    
  2        amount           NUMERIC(10,5) 0                            0    
  
  SELECT _id, name, amount FROM accounts
  </code></pre>
  
  <p>Is it possible to convert the amount in two decimal places within the select statement, so I can display with two decimal places in the application.
  I need to format in the select statement, don't wants to change the table structure. Thanks in advance.</p>
  
  <p>Im using following code to populate the the list view in android </p>
  
  <pre><code>    cursor = dbAdapter.getAccountsTotals(); 
      startManagingCursor(cursor); 
      String[] from = new String[] { DbAdapter.KEY_ID, DbAdapter.KEY_NAME, DbAdapter.KEY_AMOUNT}; 
      int[] to = new int[] { R.id.dis1, R.id.dis2, R.id.dis3}; 
      SimpleCursorAdapter trans = new SimpleCursorAdapter(this, R.layout.accts_row, cursor, from, to); 
  setListAdapter(trans); 
  </code></pre>
  
  <p>so can not format the results after fetching form the database. Please let me know it there is a way to assign formatted values in above code, thanks.</p>