How to convert this to proper date format??

[qingbo]

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