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