Try

Select * from ..where field>('NOW'- . )



Regards,

Paul



From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Harriv
Sent: Friday, October 03, 2008 07:45
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Backporting query to Firebird 1.5



Hi,

I have this query which works with Firebird 2.1:

SELECT * FROM TABLE WHERE TIMESTAMPFIELD > (CURRENT_TIMESTAMP - CAST(?
as DECIMAL(18,9))

However, if I try to execute this in older system with Firebird 1.5,
I get "Unknown data type" error. I tried different variations of CAST,
but couldn't find out the working combination since I don't quite
understand the problem. Any ideas how to fix this?





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