Re: How to know day of a date?

From: Balakrishnan Subramanian <bala.subramanian_at_mci.com>
Date: 1997/06/18
Message-ID: <33A8068C.41202724@mci.com>#1/1

You can use DATE FORMAT. Few examples :

SQL> select to_char(sysdate,'DAY') from dual;

TO_CHAR(SYSDATE,'DAY')

---

WEDNESDAY SQL> select to_char(to_date('1991/01/01','YYYY/MM/DD'),'Day') from dual;

TO_CHAR(TO_DATE('1991/01/01','YYYY/MM/DD'),'DAY')

---

Tuesday

Hope this will help.

Bala.

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)
  Received on Wed Jun 18 1997 - 00:00:00 CDT