Re: Date comparison

["Hauser, Birgitta" <Birgitta.Hauser@xxxxxxxxxxx>]

Hi,
 
>>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
 
The example above will work correctly as long as nbdays will be less than or
equal 30 day. 
To make it also work correctly for more than 30 days it must be changed as
follows:
 
C/EXEC SQL Delete from MyLib/MyFile 
C+                where (Days(Current_Date) - Days(Date(DateFieldOfMyFile)))
>= :nbdays
C/END-EXEC

 

Birgitta