title: How to convert the UNIX TIME into SQL datetime format
body: <pre><code>select COUNT(DISTINCT devices) AS "Devices" from measure_tab where 
    measure_tab.time &gt;= 1375243200 and 
    measure_tab.time &lt; 1375315200;
  </code></pre>
  
  <p>The output of the above sql query gives a table with a column named "Devices" with number of devices. I want the time which is one of the attributes of measure_tab should also get displayed in another column of the output table with the UNIX TIME which is 1375243200 in this query converted into the SQL datetime format which is <code>Thu Aug  1 00:00:00 UTC 2013</code>. </p>
  
  <p>Can someone help me out?</p>
  
  <p>Thanks</p>