Re: Days of the week function

From: John Alexander <jalexander_at_summitsoftwaredesign.com>
Date: Thu, 09 Nov 2000 12:56:20 GMT
Message-ID: <U9xO5.24244$vc3.2773011_at_typhoon.tampabay.rr.com>

SQL> select to_char(sysdate,'DAY')
  2 from dual
  3 /

TO_CHAR(S

---

THURSDAY John Alexander
St. Petersburg, FL
www.SummitSoftwareDesign.com

<nsaccan_at_my-deja.com> wrote in message news:8ue56f$k6r$1_at_nnrp1.deja.com...
> Hi, all.
>
> I'm using Oracle 8.1 server.
>
> Can someone please tell me if it exists a
> function returning the day of the week (the name
> or a number) corresponding to a given input date??
>
> Otherwise, how would be possible to implement it?
>
> Thanks
>
> Nicola Saccani
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Received on Thu Nov 09 2000 - 13:56:20 CET