RE: Can I get the Day of the week?

[rob@xxxxxxxxx]

Correct.

Rob Berendt

==================
Remember the Cole!


                                                                                
                                       
                    "Phil"                                                      
                                       
                    <sublime78ska@yah        To:     <RPG400-L@midrange.com>    
                                       
                    oo.com>                  cc:                                
                                       
                    Sent by:                 Subject:     RE: Can I get the Day 
of the week?                           
                    owner-rpg400-l@mi                                           
                                       
                    drange.com                                                  
                                       
                                                                                
                                       
                                                                                
                                       
                    05/16/01 09:48 AM                                           
                                       
                    Please respond to                                           
                                       
                    RPG400-L                                                    
                                       
                                                                                
                                       
                                                                                
                                       




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
+---




+---
| 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
+---