title: Convert text value ( 6/1/2018 11:34:33 PM , 6/2/2018 2:32:07 AM) to timestamp
body: <p>I have a column with text datatype in PostgreSQL with values below:</p>
  
  <pre><code>6/1/2018 11:34:33 PM
  6/2/2018 2:32:07 AM
  </code></pre>
  
  <p>I want to convert it to timestamp:</p>
  
  <pre><code>2018-01-06 23:34:333
  2018-02-06 02:32:07
  </code></pre>
  
  <p>How do I do it?</p>
  
  <p>I tried <code>to_timestamp(entry_time_stamp, 'YYYY-MM-DD HH24:mi:ss')</code> but it does not add PM value to it.</p>