day of week function

[Viet Nguyen]

Thank you- 

-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Ken Langendock
Sent: Thursday, February 03, 2005 2:54 PM
To: PowerH List
Subject: Re: day of week function

Here is a sample defined item that should answer your
question

DEFINE D_DOW CHAR*9 = &
        "Monday" IF 1 = MOD(DAYS(EFF_DATE),7) &
   ELSE "Tuesday" IF 2 = MOD(DAYS(EFF_DATE),7) &
   ELSE "Wednesday" IF 3 = MOD(DAYS(EFF_DATE),7) &
   ELSE "Thursday" IF 4 = MOD(DAYS(EFF_DATE),7) &
   ELSE "Friday" IF 5 = MOD(DAYS(EFF_DATE),7) &
   ELSE "Saturday" IF 6 = MOD(DAYS(EFF_DATE),7) &
   ELSE "Sunday" IF 0 = MOD(DAYS(EFF_DATE),7)

Ken

 --- Viet Nguyen <VNguyen@wsboces.org> wrote: 
> Please can someone tell me how to get  day of week
> (Monday, Tuesday )
> from sysdate . I looked at dateextract but it
> doesn't allow for this
> option.
> 
> Thanks
> 
> Viet.
> 
>  
> 
>  
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.