How to convert this to proper date format??

I have a field named expire_dt. It's a char(10). For example:

EXPIRE_DT
----------
2002-08-31
2002-08-31


How to convert that to this:

Aug/31/01

Thanks

Qingbo

Hi

If u want to display in the req format

it is To_char(column_name ,'mon/dd/yy')

Thanks
lnr

select to_char(sysdate,'Mon/DD/YY') from dual;

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