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

Would do it, but I get:

ISC ERROR CODE:335544569

ISC ERROR MESSAGE:
Dynamic SQL Error
expression evaluation not supported

None of the UDFs for Linux seem to have an aging function (I know
FreeUDFLibC has one, but it doesn't work correctly, and only
works with months).

Paul





Paul Schmidt
Tricat Technologies
paul@...
www.tricattechnologies.com