title: Turning 8 characters unix timestamp into datetime
body: <p>I got a table which include event time as timestamp, but there are only 8 characters in it, for example</p>
  
  <pre><code>2015-04-01 as 22481616,
  2015-04-02 as 22568016,
  2015-04-03 as 22654416,
  2015-05-02 as 25160017,
  2014-12-01 as 12030816
  </code></pre>
  
  <p>I try to select hour and minute from unix timestamp but i can't. any idea?</p>