Re: Date questions

From: Herbert Tessemaker <J.Hoekstra_at_civ.utwente.nl>
Date: 1998/01/27
Message-ID: <01bd2b3c$4c8727c0$7c025982@utciv2124.civ.utwente.nl>#1/1

Use this: to_char(sysdate,'DAY')
it returns TUESDAY

> >
> > 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.?
> >
> >
> > Laura Bellini
>
> First, to find out what weekday the date is, convert the date using a
>
> format-mask:
>
> to_char(date, 'D')
>
Received on Tue Jan 27 1998 - 00:00:00 CST