title: How to Change date format in hive
body: <p>I have one table in hive with column "dates"(String) and value as "5/29/2014 11:58:02 AM".
  I need to change the datatype from string to timestamp to process the data,I have created temporary table and trying to insert data from the original table:</p>
  
  <pre><code>create table temp as select 
   level,
   from_unixtime(unix_timestamp(dates,'YYYY-MM-DD HH:MM:SS')) as newTime,
   source,
   eventid,
   task,
   description,
   category 
  from logs;
  </code></pre>
  
  <p>It didn't work .How to solve this?
  please help.</p>