Re: How to know day of a date?

From: Timo Haatainen <Timo.Haatainen_at_tietogroup.com>
Date: 1997/06/10
Message-ID: <339CF0D2.5B3A@tietogroup.com>#1/1

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)

Here are some examples. For more information see SQL Reference, Date Format Elements.

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

TO_CHAR(SYSDATE,'DAY')

---

tuesday

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

TO_CHAR(SYSDATE,'DY')

---

tue

-- 

Timo Haatainen
Carelcomp Forest Oy

Received on Tue Jun 10 1997 - 00:00:00 CDT