And using CAST:


SELECT FIELD1 FROM TABLE1 WHERE TABLE1.DATE >
CAST('TODAY' AS DATE)- 30

Artur

----- Original Message -----
From: Sandeep
To: ib-support@yahoogroups.com
Sent: Tuesday, February 19, 2002 10:01 PM
Subject: Re: [ib-support] Aged Dates


On 19 Feb 2002, at 15:53, Paul Schmidt wrote:

>
> Dear List:
>
> I am using Firebird running on Linux Version (LI-T6.2.681 Firebird
> Release Candidate 2) .
>
> I have a set of dates in a table, and I want to split them up as 30.
> 60, 90 etc. I would have thought that
>
>
> SELECT FIELD1 FROM TABLE1 WHERE TABLE1.DATE >
> 'TODAY' - 30

following should work
SELECT FIELD1 FROM TABLE1
WHERE TABLE1.DATE > current_date - 30


Regards

Sandeep

Software Developer
CFL
sandeep@...
http://www.cfl.co.nz



[Non-text portions of this message have been removed]