title: Need to change date formate to date (YYYYMMDD) format
body: <p>Here the requirement is to convert sysdate to in to YYYYMMDD in date format. Here issue it converts this in string but I need this to convert in date format in YYYYMMDD form.</p>
  
  <pre><code>select to_char(trunc(sysdate-1),'YYYYMMDD') cdr_date from dual;
  </code></pre>