title: date conversion from DD/MM/YYYY HH:MM:SS to YYYYMM
body: <p>i want to convert date to some other format.</p>
  
  <p>Below is the example <code>04/03/10 09:00:50.000000000 AM</code>to YYYYMM</p>
  
  <p>Iam not able to get this , below is the query which i used to convert.</p>
  
  <pre><code>select to_char(to_date('04/03/10 09:00:50.000000000 AM','MM/DD/YYYY HH:MM:SS AM'),'YYYYMM') from table;
  </code></pre>
  
  <p>Iam getting exception as below</p>
  
  <p><strong>ORA-01810: format code appears twice
  01810. 00000 -  "format code appears twice"</strong></p>