Re: How to know day of a date?

From: Chuck Hamilton <chuckh_at_dvol.com>
Date: 1997/06/10
Message-ID: <33a15430.4599803@news.dvol.com>#1/1

Gang - Feng <g0f4653_at_cs.tamu.edu> 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 TO_CHAR function.

TO_CHAR(mydate,'DAY')

--
Chuck Hamilton
chuckh_at_dvol.com

This message delivered by electronic sled dogs. WOOF!

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