try

SELECT * FROM TABLE WHERE COLUMN >= CURRENT_DATE-30

Regards
Gary

----- Original Message -----
From: "mcbootchek" <petr@...>
To: <firebird-support@yahoogroups.com>
Sent: Wednesday, November 10, 2004 10:32 PM
Subject: [firebird-support] Re: Subtract from date, Now


>
>
> --- 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))
>