title: Date Conversion in Oracle (YYYYMMDD format back to YYYYMMDD)
body: <p>Hi I am pretty much new to Oracle and need an idea on how to do it. </p>
  
  <p>Consideer I have a Text file and the value in the file is </p>
  
  <p>'20180924' 
  '20180923'</p>
  
  <p>I read these value from the Pro*c and then I add 29 days to it, so the value now changes from 20180924 to 20180953. I don't want that to happen i want the value to be added as </p>
  
  <pre><code> TO_DATE('20180924','yyyymmdd')+29 which returns the value as "23-OCT-18" 
  </code></pre>
  
  <p>The answer is correct but i want the result to also be in the same <strong>YYYYMMDD</strong> format like <strong>20181023.</strong> </p>
  
  <p>How do i achieve this ?</p>