Convert Day of week (DY) to actual date

We have a table (duh!) with columns that users have been entering day abbreviations - MON, TUE, WED, etc...

I would like to convert these days to actual dates, so that WED would be 18-Aug-2004, or whatever format I end up specifying.

I have currently tried:

select to_date(s_day, 'DD')

which returns:

ERROR at line 1:
ORA-01858: a non-numeric character was found where a numeric was expected

Thanks for any assistance!!! Received on Wed Aug 18 2004 - 13:25:22 CDT