Re: Day of week function?

From: Bob Cunningham <bcunn_at_oanet.com>
Date: Mon, 01 Jun 1998 22:56:55 GMT
Message-ID: <3573306d.88509165@news.oanet.com>

On Mon, 1 Jun 1998 22:36:27 GMT, "Mark Aurit" <mark_aurit_at_mail.northgrum.com> wrote:

>Is there a function available where I can check for the day of week, so I
>can
>do something like:
>
>if day_of_week_is('Friday',sysdate) then
> ... perform friday processing
>else
>... perform other days processing
>end if
>
>Thanks, Mark

Check out the TO_CHAR function. The format mask elements for use with dates can provide the day of the week (D) or the full (DAY), or abbreviated (DY), name of the day.

>auritma_at_mail.northgrum.com

Bob Cunningham
bcunn_at_oanet.com Received on Mon Jun 01 1998 - 17:56:55 CDT