Re: How to know day of a date?

Gang - Feng wrote:
>
> How could I know which date is on which day? I mean given a specific
> date like 1997/01/01, how to get which day it is like Sunday, Monday or
> so on. Thanks a lot.
> Please give me an email because I can't always check this news group.
>
> Gang Feng (mailto:g0f4653_at_cs.tamu.edu)

Use the DAY function (check you SQL reference manual). For example, to see the current day use
select to_char(sysdate,'DAY') from dual;

-- 
****************************************
Jay Hostetter                          *
D. and E. Communications               *
Ephrata, Pa.  U.S.A                    *
Remove underscores in address to reply.*
****************************************