title: How To Format Timestamp
body: <p>I have <code>col1</code> in <code>myTable</code> which is <code>varchar</code>, and I have to insert here timestamp eg:- <code>09-MAY-11 10.23.12.0000 AM</code>.</p>
  
  <p>Now please tell me:</p>
  
  <ul>
  <li>How to insert into myTable with taking sysdate in above format...</li>
  <li>How to retrieve data from col1 in tha same timestamp format..</li>
  </ul>