title: Converting TIMESTAMP column in 12 HR format into Date column with 24 HR format
body: <p>In a table, I have a TIMESTAMP column in 12 HR format which I want to convert into Date column with 24 HR format.</p>
  
  <pre><code>Insert_Date
  
  3-JAN-19 09.50.25.000000 AM 
  
  23-JAN-19 08.54.37.000000 PM
  </code></pre>
  
  <p>I tried following-</p>
  
  <pre><code>to_char(Insert_Date,'YYYY-MM-DD HH:MI:SS')
  </code></pre>
  
  <p>Expected Result is -</p>
  
  <pre><code>3-JAN-19 09.50.25
  
  23-JAN-19 20.54.37
  </code></pre>