title: How can I convert micro-cents into dollars without losing decimal precision?
body: <p>I have a column that stores transaction amounts in 'microcents'</p>
  
  <p>e.g. <code>127740000</code>    microcents which corresponds to <code>127.74</code> USD</p>
  
  <p>I cannot figure out how to get write a query to return 127.74 for me. If I do.</p>
  
  <p><code>SELECT microcents/1000000</code> </p>
  
  <p>it truncates the return to 127 and I lose the cents</p>