Hello,

I need a select that can return all records
more than one hour old.

Firebird 1.5 dilect 1

I tried
select * from file
where fDate < cast('now' - (1/24) as date)
but I get "Overflow occurred during data type conversion from string "now""

Also, tried asorted other things. But I am unable to get it to work.

Any ideals?

Thanks
Michael L. Horne