Hi:
Then your query is:
SELECT * FROM table WHERE date between today and today -10.
And the results including today and yesterday and the day before yesterday
etc..., up
to 10 days ago.

gillianleech@h... wrote:

> >
> What if I want to do the following
>
> SELECT * FROM table WHERE date <= TODAY - 10 days
>
> I want to return rows from the table where the dates are 10 days ago.
>
> So including today and yesterday and the day before yesterday etc..., up
> to 10 days ago
>
> Include eveything including today up to 10 days ago
>
> > Hi
>
> > does anyone know how to get the current date in informix?
>
> > also, i'd like to get the date 10 days ago
>
> > e.g. select thisdate from tbldate where thisdate = todaysdate
>
> > e.g. select thisdate from tbldate where thisdate = todaysdate - 10 days
> ago