title: to change date from string to date type in hive
body: <p>I want to change string which is in format <code>dd/mm/yyyy</code> to date type in hive.</p>
  
  <p>I am using hive version 1.0.0 . I have tried using:</p>
  
  <pre><code>TO_DATE(from_unixtime(UNIX_TIMESTAMP('07/03/2013', 'dd/mm/yyyy'))) 
  </code></pre>
  
  <p>But it returns <code>NULL</code>. Although it works with format <code>'dd-mm-yyyy'</code>. But it returns NULL with <code>'dd/mm/yyyy'</code>. </p>
  
  <p>I have tried using <code>CAST</code> also but it also does not give me the correct result. </p>