title: convert 090216 (string) into 16-FEB-09 (date) in hive
body: <p>so I am trying to convert
  <code>0902160918 (string)</code>
  into
  <code>16-FEB-09</code></p>
  <p>My current work:</p>
  <pre><code>SELECT
    date_format(from_unixtime(unix_timestamp(SUBSTR(DATE_TIME,1,6),'yyMMdd'),'yy-MMM-dd'))    
  FROM 
    table_name
        ;
  </code></pre>
  <p>What is the best practice to convert this? Should I input <code>concat</code> or something?</p>
  <p>All helps or ideas surely will be appriciated.</p>