Christina and All:
Must be my incrementing years, but now remember the syntax. A Big Thanks to
you all who replied!
Have a great weekend!
JP in CA (no cell)
-----Original Message-----
From: Hasse, Christina [mailto:[log in to unmask]]
Sent: Friday, June 04, 2004 10:51 AM
To: Penney, John
Subject: RE: Day of Week
Hi John,
It is:
define day-no num*1 = mod(days(sysdate),7)
define day-of-week char*10 = case of day-no &
when 0 then "Sunday" &
when 1 then "Monday" &
when 2 then "Tuesday" &
when 3 then "Wednesday" &
when 4 then "Thursday" &
when 5 then "Friday" &
when 6 then "Saturday"
Regards,
Christina Hasse
ADT N.A. Technical Manager
COGNOS CORPORATION
425 North Martingale Road, Suite 600
Schaumburg, IL 60173
[log in to unmask]
Office: 847 - 285 - 2905
Cell: 847 - 269 - 1909
Fax: 847 - 240 - 0252
http://powerhouse.cognos.com
-----Original Message-----
From: [log in to unmask]
[mailto:[log in to unmask]]
Sent: Friday, June 04, 2004 12:36 PM
To: [log in to unmask]; [log in to unmask]
Subject: Day of Week
Gentle Listers:
Pray tell, how does one determine the day-of-week it is? I vaguely recall
some kind of Powerhouse or HP function like dayofweek = day(20040604)
returning 5=Friday?
Or was that in another incarnation? 8=)
Many thanks for your input.
Happy Friday in any event!
John M Penney
DDPS
California Department of Corrections
1920 Alabama Ave.
Rancho Cordova, CA
(916)358-2247
(916)358-2322 Fax
(360)789-8159 Cellular
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: [log in to unmask]
Subscribe: "subscribe" in message body to [log in to unmask]
Unsubscribe: "unsubscribe <password>" in message body to
[log in to unmask]
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
This message may contain privileged and/or confidential information.
If you have received this e-mail in error or are not the intended recipient,
you may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. Thank you.
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|