Re: Date questions

Laura Bellini wrote:
> Can someone tell me how to just get the day of the week out of a date in
> Oracle?

SELECT TO_CHAR(date_column,'DAY') FROM TABLE;

If you use the mask 'DAY' you will get the day name in all UPPER CASE, 'Day' will get you Capitalised, 'day' will get you all lower case.

-- 
James "I'd rather fall off Ilustrada than ride any other horse" Petts