title: Inserting date and Timestamp giving error
body: <p>I want to insert <code>Current_timestamp</code> in an Oracle table. And,I have tried things like <code>to_timestamp(current_timestamp,'YYYY-MM-DD HH24:MI:SS:FF')</code> but its giving error as</p>
  
  <pre><code>ORA-01830: date format picture ends before converting entire input string
  01830. 00000 -  "date format picture ends before converting entire input string"
  *Cause:    
  *Action:
  </code></pre>
  
  <p>Also thanks a lot for your answers when i did    <code>'select current_timestamp,systimestamp from dual;</code>' then it gave me </p>
  
  <pre><code>'CURRENT_TIMESTAMP                    
  --------------------------------------
  25-NOV-16 12.03.04.605812000 PM ASIA/C 
  ALCUTTA ' whereas when i did -'select systimestamp from dual;' I got 'SYSTIMESTAMP                         
  --------------------------------------
  25-NOV-16 06.33.04.789680000 AM +00:00 
  </code></pre>
  
  <p>'.</p>
  
  <p>Now i want to insert in the format <strong>25-NOV-16 06.33.04.789680000</strong> along with many other feilds. 
  Kindly help.</p>