Question: how to convert date format yyyy-mm-dd to dd-mm-yyyy in oracle?
Answer: 1 Answer. Use this combination of to_char and to_date : select to_char (to_date('20150324','YYYYMMDD'), 'DD-Mon-YY') from dual; Your mistake was, that you used the wrong date pattern.