title: converting date into char in AS400
body: <p>I am trying to convert the current date - 2 months into format yyyymmdd and subtract 1900000 from it. </p>
  
  <p>Oracle was easy for me </p>
  
  <pre><code>SELECT  TO_CHAR(ADD_MONTHS(SYSDATE,-2),'YYYYMMDD') - 19000000 FROM DUAL 
  </code></pre>
  
  <p>Can some one suggest me the same for <strong>AS400</strong> . </p>
  
  <p>Thanks in advance. </p>