Re: Help! SQL example needed for date comparison!

In informix, while doing date manipulation, you sometimes have to use 'Unit' keyword to identify the type of manipulation. I forgot the exact syntax but it can be : select * from table where table.datecolumn=today-15 unit day (to subtract 15 number of days) select * from table where table.datecolumn=today-3 unit month (to subract 3 months) select * from table where table.datecolumn=today-1 unit year ( to subract 1 year) Please recheck with Informix manual to recheck this or to get exact syntax. Regards Fateh fateh.ahmad@cressoft.com.pk >