How to convert this to proper date format??

[rsuri]

If your column is CHAR type then you will have to convert that to DATE form before using to_char function. So your query will be more likely as follows --

select to_char(to_date(expire_dt, 'yyyy-mm-dd'), 'Mon/dd/yy') from dual;


- Rajeev