[firebird-support] Select with a timestamp + 24 hours

['Paul Coshott' p...@coshott.com [firebird-support]]

Hi All,

 

I have a table with a timestamp field. I need to perform a select to return
records that are more than 24 hours past the timestamp value.

 

So something like:

 

Select from STAFF where PASSWORD_TIME + 24 hours < Now

 

Can anyone tell me how to do this?

 

Thanks,

Paul