title: Inserting timestamp in oracle timestamp column
body: <p>I have a table in which there is a column with datatype <code>TIMESTAMP(0)</code>  </p>
  
  <p>When I insert a date into this column using</p>
  
  <pre><code>INSERT INTO TEST_TIMESTAMP VALUES(SYSDATE)
  </code></pre>
  
  <p>it inserts a date in the following example format </p>
  
  <p><code>12-SEP-12 10.31.19.000000000 AM</code></p>
  
  <p>I want to know how the below timestamp formats can be inserted in the table  </p>
  
  <p><code>12-SEP-12 10.31.19</code> and <code>12-SEP-12 10.31.19 AM</code></p>
  
  <p>I tried specifying some formats using <code>TO_CHAR</code> while inserting <code>SYSDATE</code> into the table, but it didn't work.</p>
  
  <p>Please suggest.</p>