title: Format conversion for TimeStamp to Date
body: <p>I need to convert data for all files which have below :</p>
  
  <pre><code>TO_DATE('01/31/1970 12:00:00 AM','MM/DD/YYYY HH:MI:SS AM')
  </code></pre>
  
  <p>to simple <code>31-JAN-1970</code> format using some automation (bash/Linux/UNIX command should do)</p>