title: how to convert string format to date format in hive
body: <p>I've timestamp and date columns in my table. My date and timestamp columns are in string type. I need to convert it to DATE and TIMESTAMP format. But the format in my data is 2/4/2017 3:03. So when I convert it to TIMESTAMP datatype it gives NULL. What can we do to resolve this? </p>
  
  <p>Here is my sample date&amp; time column data.</p>
  
  <pre><code>2/3/2017 23:37
  2/3/2017 23:37
  2/3/2017 23:40
  2/3/2017 23:50
  2/3/2017 23:51
  2/3/2017 23:53
  2/3/2017 23:55
  2/4/2017 0:08
  2/4/2017 0:57
  </code></pre>
  
  <p>Thanks in advance</p>