title: Converting a Date Format to YYYYMM in Cognos Report Studio
body: <p>I have a date column in a format <code>12 May, 2014</code> I want to convert that into <code>yyyymm/ 201405</code> format. 
  i tried multiple options like </p>
  
  <pre><code>extract(year, sys_date)*100 + extract(month, sys_date))*100
  cast(extract( year, sys_date), varchar(4)) + cast(extract( month, sys_date), varchar(2))
  </code></pre>
  
  <p>This one works but returns me in <code>YYY,YMM</code> format. </p>
  
  <pre><code>CAST(to_char(sys_date, 'YYYYMM'), INT )
  </code></pre>
  
  <p>For the above two, it gives an error:</p>
  
  <pre><code> An error occurred while performing operation 'sqlOpenResult' status='-28'
  </code></pre>
  
  <p>Can some one please guide. Thank you in advance. </p>