Re: SQL and Dates, help needed

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Better idea to convert the date to numeric...

That way the query engine can still use indexes.

Either right your own or use iDate
http://www.think400.dk/downloads.htm

Charles


On Thu, Sep 8, 2011 at 1:26 PM,  <Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx> wrote:
> Did you convert the numeric field to date before trying to compare?
>
>
>
> From:   "Al Nelson" <Al.Nelson@xxxxxxx>
> To:     <RPG400-L@xxxxxxxxxxxx>
> Date:   09/08/2011 12:23 PM
> Subject:        SQL and Dates, help needed
> Sent by:        rpg400-l-bounces@xxxxxxxxxxxx
>
>
>
> I'm trying to select all the records in a file that have yesterday's date.
> The field in the file is defined as numeric 8 positions and 0 decimals.
> It is in a YYYYMMDD format.
>
> I would think a Select with Current Date - 1 would work but is does not.
>
> any suggestions.
>
> thanks
>
> al
>
> --
> This is the RPG programming on the IBM i / System i (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.
>
>
> --
> This is the RPG programming on the IBM i / System i (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.