Querying Informix Database by Date Range

[safari7391]

How can I use this statement to query an Informix database from SQL Server Enterprise Manager?

where (row_date BETWEEN { fn NOW() } - 15 AND { fn NOW() } - 10)

 

[olded]

Hi:

In informix you must use the today keyword. Assuming row_date is a date type:

... where row_date between today - 15 and today -10

Regards,


Ed