I need to get all rows which expire within 30 days.
It seems like Firebird does not support GetDate() etc...
I was looking for something like this, for example:
SELECT * FROM TABLE1
(ExpireDate >= DATE - 30)
BTW: "ExpireDate" is the database fieldname of type date