Re: Date questions

Laura Bellini wrote:
>
> Hi -
> Can someone tell me how to just get the day of the week out of a date in
> Oracle?
>
> For example, is 1/19/98 a 'monday', 'tuesday', 'wednesday', etc.?
>

 <snip>

Hi

Try

  select to_char(sysdate, 'day') from dual;

            or
  select to_char(to_date('01/19/98', 'mm/dd/yy'), 'day') from dual;

rgds
eugen Received on Tue Jan 20 1998 - 00:00:00 CST