title: how to convert YYYYMMDD to DD-Mon-YYYY in oracle?
body: <p>I am trying to convert the date from <strong>YYYYMMDD</strong> to <strong>DD-Mon-YYYY</strong> in Oracle, but <code>to_char</code> or <code>to_Date</code> is not working. Can you please advise?</p>
  
  <p><code>select to_date(20150324,'DD-Mon-YY') from dual;
  select to_char(20150324,'DD-Mon-YY') from dual;</code></p>
  
  <p>I get an error message saying: <code>- ORA-01861: literal does not match format string</code></p>