title: How to convert a string to date with AM/PM?
body: <p>I'm trying to convert a string to timestamp in Hive</p>
  
  <p>String: <code>11/25/2014 07:58:37 AM</code></p>
  
  <p>This command works but ignores the halfday of day:</p>
  
  <pre><code>select unix_timestamp(ClosedDate, 'MM/dd/yyyy HH:mm:ss') from ...
  </code></pre>
  
  <p>I tried this: </p>
  
  <pre><code>unix_timestamp(ClosedDate, 'MM/dd/yyyy HH:mm:ss a')
  </code></pre>
  
  <p>and this:</p>
  
  <pre><code>unix_timestamp(ClosedDate, 'MM/dd/yyyy HH:mm:ss tt')
  </code></pre>
  
  <p>but it doesn't work.</p>