Re: Date comparison

here is a sample :

C/EXEC SQL
C+                Delete from Mylib/MyFile  where
c+                current_date - date(DateFieldOfMyfile) >= :nbdays
C/END-EXEC

NBDays is a numeric value


----- Original Message ----- 
From: "Stiju Easo" <stiju.as400@xxxxxxxxx>
To: "RPG programming on the AS400 / iSeries" <RPG400-L@xxxxxxxxxxxx>
Sent: Thursday, April 13, 2006 8:39 AM
Subject: Date comparison


> Hi,
>     Thanks for earlier help,
>     I have compled it.
>
>      I didnt use SQLRPG till now
>      I want to do a date comparison
>      Problem is the field in PF is TIMESTAMP field
>
>      My requirment is to delete records which are 30 days old
>      EUCRDT will have time stamp  in ISO format
>
>      I need to compare date of it with current date , and delete records
> with date more than 30 days ago
>
>      please help me me to find current date
>      also the functions for finding datr difference (I dont know is it
> better to do in Native RPG or Embeded SQL)
> -- 
> 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.
>
>