Hi I have some simple sql as shown below

Basically I am looking for pins with a range of status settings that
are over an hour old, when I have it working I can turn it unto an update.

The problem comes with the ('NOW' - STATUS_CHANGED) > 1/24
(STATUS_CHANGED IS A TIMESTAMP) , trying to run the sql I get an error
about not being able to do the comparison?

Can anyone indicate what I am doing wrong ?

SELECT * FROM PINS
WHERE
(STATUS = 7 OR STATUS = 8 OR STATUS =1 OR STATUS =9) AND
(('NOW' - STATUS_CHANGED) > ( 1/24))

Rgds

Peter