Re: Convert Day of week (DY) to actual date

"Richard Brust" <richard_brust_at_yahoo.com> a écrit dans le message de news:8b15ae11.0408181025.e180a60_at_posting.google.com...
> 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!!!

What is the meaning of to_date('MON',...)? Which Monday?

-- 
Regards
Michel Cadot