--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:

>
> > I need to run a query including the last 30 days. I am thinking
> > something along the lines of
> >
> > SELECT * FROM TABLE WHERE COLUMN<='NOW'-30;
> >
> > But I know the above does not work
> >
> > Any ideas or suggestions
>
> current_date-30
>

in my selects following works well

WHERE
(DKLEVDM01.D$PORIZENO > ('now'-2))