title: hive casting date
body: <p>In a hive table I have bunch of date that are in integer format. </p>
  
  <p>Example</p>
  
  <p>Table</p>
  
  <pre><code>Date
  2015051517
  2015051518
  2015081517
  </code></pre>
  
  <p>Query</p>
  
  <pre><code>SELECT CAST(date TO INT)
  FROM date_table;
  </code></pre>
  
  <p>How do I get the above example like below?</p>
  
  <pre><code>date
  -------------
  2015-05 15:17 
  2015-05 15:18
  2015-08 15:17
  </code></pre>
  
  <p>Thanks in advance!i</p>