RE: Can I get the Day of the week?

["Phil" <sublime78ska@xxxxxxxxx>]

Just to verify . . .
You need the SQL Development kit to compile ONLY.  The compiled SQLRPGLE
object will run regardless of whether the development kit is installed or
not.

Correct?  Or am I wrong?

Phil

-----Original Message-----
From: owner-rpg400-l@midrange.com [mailto:owner-rpg400-l@midrange.com]On
Behalf Of Rolf Mittag
Sent: Wednesday, May 16, 2001 3:54 AM
To: RPG400-L@midrange.com
Subject: Re: Can I get the Day of the week?

I did some research for that a while ago :

the date data type is a so called "Lillian Date" and
is not defined for dates before the change of calendar
that you mentioned. I took that from the manuals
but can't remember from which.

how about :

c/exec sql set :dow = dayOfWeek(:date)
c/end-exec

if you have SQL of course

---------------------------
Dipl.Inf.(FH) Rolf P Mittag
IBM Partner in Development
Leipziger Str. 50
D-69214 Eppelheim
Fon: +49 (6221) 76 78 60
Fax: +49 (6221) 76 80 26
eMl: rm@r-m-e-d-v.de

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---