title: Apache Hive: How to convert string to timestamp?
body: <p>I'm trying to convert the string in <code>REC_TIME</code> column to a timestamp format in hive. </p>
  
  <p>Ex: <em>Sun Jul 31 09:28:20 UTC 2016 <strong>=></strong> 2016-07-31 09:28:20</em> </p>
  
  <pre><code>SELECT xxx, UNIX_TIMESTAMP(REC_TIME, "E M dd HH:mm:ss z yyyy") FROM wlogs LIMIT 10;
  </code></pre>
  
  <p>When I execute the above SQL it returns a NULL value.</p>