RE: handling date data types

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Can he use SQL?

select month(mydate), day(mydate), year(mydate), mydate
from rob/prowak
MONTH ( MYDATE )  DAY ( MYDATE )   YEAR ( MYDATE )  MYDATE
             12               31            2,002   2002-12-31

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin




"Prowak, Dave" <DProwak@ci.syracuse.ny.us>
Sent by: rpg400-l-admin@midrange.com
10/15/2002 02:05 PM
Please respond to rpg400-l


        To:     rpg400-l@midrange.com
        cc:
        Fax to:
        Subject:        RE: handling date data types


< Why the hell do you want to stick with RPG400 instead of RPGLE?
I use RPG IV for all of my code.  This question came from another
programmer who doesn't use RPG IV.


-----Original Message-----
From: rob@dekko.com [mailto:rob@dekko.com]
Sent: Tuesday, October 15, 2002 12:51 PM
To: rpg400-l@midrange.com
Subject: Re: handling date data types


This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
It is possible, you can read a date field as a character field and process
accordingly.  There is some compile option to address this.

<rant on>
You obviously are using new data - a date field.  Therefore even the poor
excuse "because that is what my package is written in" doesn't even apply.
 Why the hell do you want to stick with RPG400 instead of RPGLE?
<rant off>

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin




"Prowak, Dave" <DProwak@ci.syracuse.ny.us>
Sent by: rpg400-l-admin@midrange.com
10/15/2002 11:07 AM
Please respond to rpg400-l


        To:     rpg400-l@midrange.com
        cc:
        Fax to:
        Subject:        handling date data types


Hi,

Is it true that using RPG400 it is NOT possible to extract the month, day
or
year from
a date data type?

Dave
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.



_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.