> Hi List,
>
> This should be simple but though reading the doc's can't figure it out
- I'm
> hopeless at intrepreting documentation.
>
> I just want to extract from a table containing entries with dates, all
entries
> from within a specified interval eg last month, or last 10 days.
>
> Any help appreciated.
>
> Richard
Your post isn't the clearest, but there are a few ways of accomplishing
this. Probably the easiest is:
...WHERE date_field>=(CURRENT_DATE-INTERVAL '10 days')
...WHERE date_field>=(CURRENT_DATE-INTERVAL '1 month')
And so on.