Re: Date conditioned SQL Select

Interesting, I would have never thought to do it that way. Anyway, did you
mix that up?  I think the other guy would want to add 19000000 to filedate.


Dig in! Bob Evans New Knife & Fork Sandwiches -- This much homestyle
goodness demands a Knife & Fork!


rpg400-l-bounces@xxxxxxxxxxxx wrote on 09/11/2006 06:30:26 PM:

klerpg@xxxxxxxxxxxxx wrote:

I have a file that I need to read based on a user-input date field
(CCYYMMDD). The file field I am comparing to is a 7 digit date field
(CYYMMDD).

In SQL, how do I get the select statement to pull records based on a
comparison of these two fields?

If we make the following assumptions:

Today's date is 20060911  and it's represented in the file as 1060911,

then

all we have to do is to add the difference of the 2 values to the smaller

to get them to compare.

Select * from filename where filedate=(userdate + 19000000)

bill


--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing

list

To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.